Ask Your Question
1

How to open CSV with different decimal separator?

asked 2017-11-13 21:17:05 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello I have a LibreOffice Version: 5.1.6.2 in Ubuntu 16.04 LTS. I have a set of CSV files that have decimal separator ".", but in Brazil the decimal separator is ",". When I open in LibreOffice the value appears, for example, 123.34 - instead of 123,34 Please, is there a way for importing the CSV from choosing the decimal separator? How is it done in Excel. Or what command within LibreOffice to change the default of the decimal separator? Thank you

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2017-11-13 22:42:05 +0100

Lupp gravatar image

If you open a csv file with LibO you are asked what language settings to use for the import (immediately below the character set). Select English(UK) there (e.g.).
This shouldn't afflict the document language you have sez otherwise.

edit flag offensive delete link more
0

answered 2017-11-14 00:31:26 +0100

Reinaldo Chaves gravatar image

Thank you!

edit flag offensive delete link more

Comments

You're welcome!

Lupp gravatar imageLupp ( 2017-11-14 02:25:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-13 21:17:05 +0100

Seen: 513 times

Last updated: Nov 14 '17