Ask Your Question
1

How to open CSV with different decimal separator? [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-19 23:20:13.431726

2 Answers

Sort by » oldest newest most voted
1

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

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 +0200

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 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 2,025 times

Last updated: Nov 14 '17