https://bugs.freedesktop.org/show_bug.cgi?id=64696
Priority: medium
Bug ID: 64696
Assignee: [email protected]
Summary: Can't change cell from text to number
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
I brought in a .csv file in and saved it. The data column a currency say
$1.00. First, I deleted the $. Next I used format cell and turned it to number
format. Instead of becoming a number a ' showed up and the cell remain text.
Example
$1.00 became '1.00. The only way I've found to change the text to number
format is to go in and hand edit every incidence 'xxx which is very time
consuming. If I leave the $ and use format cell and choose currency the cell
goes from $1.00 to '$1.00. The text symbol does not seem to be searchable for
find and replace.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
