https://bugs.documentfoundation.org/show_bug.cgi?id=145357
Leon <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #10 from Leon <[email protected]> --- (In reply to Regina Henschel from comment #9) > 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. thanks. I basically simply do a mass replace of period to comma. I am unable to find the place where it is set as a dot. It did not used to exhibit this behaviour so I am not sure where this chnaged in the locale settings. Will close because it basically is a formatting issue where commas must be used, and not periods as decimal separator. -- You are receiving this mail because: You are the assignee for the bug.
