Converting decimal point to comma [Tips / Tricks]

posted by Helmut Homepage – Vienna, Austria, 2010-03-04 16:33 (5138 d 23:44 ago) – Posting: # 4861
Views: 8,497

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:
[image]
This procedure should convert the decimal separator from "." to the one in your localization (Belgium: ",")...

Dif-tor heh smusma 🖖🏼 Довге життя Україна! [image]
Helmut Schütz
[image]

The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

Complete thread:

UA Flag
Activity
 Admin contact
22,957 posts in 4,819 threads, 1,636 registered users;
113 visitors (0 registered, 113 guests [including 8 identified bots]).
Forum time: 16:17 CET (Europe/Vienna)

With four parameters I can fit an elephant,
and with five I can make him wiggle his trunk.    John von Neumann

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5