CSV file in Excel - Avoid default round off

New Contributor

Hi Everyone,

 

I have a csv export which has numeric and currency values with 5 decimals places. When I open it in excel, its getting rounded off by default and I need to format the cells for every file.

Is there a default setting which allows to display all the decimal values as it is in csv when we open in excel?

Ex: CSV with Tab separated

Hari101093_0-1626703345941.png

In Excel : 

Hari101093_1-1626703383893.png

 

 

3 Replies

@Hari101093 

When I open your CSV file in a text editor it shows this:

 

ID,Name,Contribution,Salary
1,Ram,10.4556,$100.46
2,Tim,20.879,$200.88

 

So everything seems to be rounded already in the CSV file.

@Hari101093 

If you double click on CSV when Excel use your regional settings to convert numbers. Thus for currencies it round to 2 decimals, for other numbers cut zeroes. You can nothing to do with that.

An option is to import csv file using Power Query or legacy From Text/CSV wizard and mark such columns as texts.

Sorry Riny. I have updated the correct file now.
Its a tab delimited file.

Thanks