Reading from .csv file

  • Thread starter Thread starter Galsaba
  • Start date Start date
G

Galsaba

I have the folowing test.csv file:

ENTITY","INTEREST ","AMOUNT "
"CSD01"," 1.4567","3,456.1234"

"CSD01","456.1234"," 1.4567 "

When I open it with excel, the number 3,456.1234
becomes 3,456.12
The number 456.1234 is the same in excel.
I do not want to change anything on the excel setting,
ie, if one wants to open my test.csv file using his excel, he will not
need to do any setting changes, and he still be able to see the entire number.

Is there a way to solve it?

Thanks,

Joe
 
Hi
AFAIK not with the file format *.csv. If both of you use Excel why not
save this file as Excel file (and format the columns accordingly)
 
Back
Top