Reading from .csv file

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
 
F

Frank Kabel

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)
 
Top