Differences
This shows you the differences between two versions of the page.
replace_decimal_position_character [2016/01/26 13:09] |
replace_decimal_position_character [2021/04/05 11:23] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Replace Decimal Position Character in Cell ====== | ||
+ | Sometimes data is imported from a source with a different locale setting. Then f. e. you got the . as a decimal position character instead of , . | ||
+ | This can be replace in LibreOffice by using the "Find & Replace" | ||
+ | |||
+ | ([0-9]*)\.([0-9]*) | ||
+ | | ||
+ | $1,$2 | ||
+ | |||
+ | |||
+ | {{: |