https://bugs.documentfoundation.org/show_bug.cgi?id=145357
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #9 from Regina Henschel <[email protected]> --- If you use View > Value Highlighting, then text is black, numbers are blue and formulas are green. In that mode you see, that cell content in E3:E10 and G3:G10 is text. Changes in cell format on existing content cannot be used for changes between data type text and data type number. To change existing 'text with decimal point' to 'number with comma separator', you can do these steps: 1. cut the text to clipboard 2. Format the (still marked) cells to "General". That is in Format > Cells > Tab numbers. Make sure the field 'language' in that tab is correct. 3. (cells still marked) Use the item "Unformated text (TSV-Calc)" from the drop-down list of the 'Paste' button in the toolbar. You get the "Text Import" dialog. 4. In that dialog click on column header (shows "Standard" as default) in the section 'Fields' and then select item "US English" in field 'Column type'. OK. To change the display of the formula result in cell E11 to "number with comma separator", go to Format > Cell > Tab numbers. Change the language to -in your case- "English (South Africa)". Do all your tries on a copy of the document! For more assistance in formatting and data type handling in Calc please use user mailing list or Ask. For me this is not a bug. -- You are receiving this mail because: You are the assignee for the bug.
