Kevin van Ockenburg wrote:
Dear Users,
.Calc
I would like to adjust the point (.) in collums with figures to a comma
(,)
For example;
2259.31 should convert to 2259,31
2140.91 should convert to 2140,91
I can offcourse adjust this manually but there should be a possibility
to select all and adjust automatically.
Kevin,
I assume that you've imported numbers from somewhere that have point (.)
in them and Calc now displays these as text because your locale uses
commas for the decimal separator. The cells themselves are hopefully
formatted as "General".
If you have text containing points (.) that you want to retain then you
can use Find and Replace and search using a regular expression to select
only cells that contain numerical characters plus the points.
Bring up the Find and Replace dialog and click on the "More Options"
button. Check the Regular Expressions checkbox and then, in the Search
For textbox, enter the following line exactly
-?[0-9]+\.[0-9]*
Now click the Find All button. This will select all cells that match,
i.e. contain a number with a point (.). Now make sure that all the
selected cells have the General format and not Text. Change them if
necessary.
Back in the Find and Replace dialog, uncheck the Regular Expressions
checkbox and enter the single character "." in the Search For textbox,
and "," in the Replace With textbox. All the previous matching cells
should still be selected. Now click the Replace All button. All the
points (.) should be replaced by commas (,) but only in the selected
cells. Calc should recognise and display them as numbers now.
Ross
PS. I see Cor Nouws has replied while I've been typing, but it looks
like you still have the select the cells to reformat in his solution.
You can use the regular expression search as described above for that.
Can somebody assist me ?
Thanks
Kevin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
