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...
excel
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