Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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" dialog and using the flag //Regular expressions//.
 +
 +    ([0-9]*)\.([0-9]*)
 +    
 +    $1,$2
 +
 +
 +{{:libreoffice-findreplace-dialog.png|}}