Mailinglist Archive: opensuse-bugs (10598 mails)
| < Previous | Next > |
[Bug 543434] Openoffice.org cannot compute SUM
- From: bugzilla_noreply@xxxxxxxxxx
- Date: Thu, 1 Oct 2009 07:30:19 -0600
- Message-id: <20091001133019.8BCA6245513@xxxxxxxxxxxxxxxxxxxxxx>
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@xxxxxxxxxx added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c4
--- Comment #4 from Kohei Yoshida <kyoshida@xxxxxxxxxx> 2009-10-01 07:30:15
MDT ---
The easiest I can think of is
1) select C2:C47
2) right-click and choose "Default Formatting" (the top item)
3) while the range is still selected, go Data - Text to Columns.
4) Click OK in the dialog.
That should mass-convert them to numbers.
--
Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
User kyoshida@xxxxxxxxxx added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c4
--- Comment #4 from Kohei Yoshida <kyoshida@xxxxxxxxxx> 2009-10-01 07:30:15
MDT ---
The easiest I can think of is
1) select C2:C47
2) right-click and choose "Default Formatting" (the top item)
3) while the range is still selected, go Data - Text to Columns.
4) Click OK in the dialog.
That should mass-convert them to numbers.
--
Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
| < Previous | Next > |