Forum Discussion

Hari101093's avatar
Hari101093
Copper Contributor
Jul 19, 2021

CSV file in Excel - Avoid default round off

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

In Excel : 

 

 

excel

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 19, 2021

    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.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 19, 2021

    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's avatar
      Hari101093
      Copper Contributor
      Jul 19, 2021
      Sorry Riny. I have updated the correct file now.
      Its a tab delimited file.

      Thanks

Resources