User Tools

Site Tools


replace_decimal_position_character

This is an old revision of the document!


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
  
  

replace_decimal_position_character.1453994700.txt.gz · Last modified: 2016/01/28 15:25 by mihael