Converting decimal point to comma [Tips / Tricks]
Ahoy!
Ha, that will cost you a bottle of your ol' reserve.
The problem is evident only on localizations of the operating system (M$-Windows, Linux) with the comma as the decimal separator. You were on the right track: import from the clipboard (unformated text) > separator: blank > combine separators >
Now you have to select each column and set the type to "US-English" > OK
Screenshot from my German version of OO Calc:
This procedure should convert the decimal separator from "." to the one in your localization (Belgium: ",")...
Ha, that will cost you a bottle of your ol' reserve.
The problem is evident only on localizations of the operating system (M$-Windows, Linux) with the comma as the decimal separator. You were on the right track: import from the clipboard (unformated text) > separator: blank > combine separators >
Now you have to select each column and set the type to "US-English" > OK
Screenshot from my German version of OO Calc:
This procedure should convert the decimal separator from "." to the one in your localization (Belgium: ",")...
—
Dif-tor heh smusma 🖖🏼 Довге життя Україна!
Helmut Schütz
The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes
Dif-tor heh smusma 🖖🏼 Довге життя Україна!
Helmut Schütz
The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes
Complete thread:
- Getting tabulated data into OpenOffice Calc ElMaestro 2010-03-03 22:02
- Converting decimal point to commaHelmut 2010-03-04 15:33