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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading from test.csv file 5
Write to a CSV file 1
copy recordset to CSV file 1
Export to CSV file problems 4
CSV 1
Forcing Excel to Import .CSV data 2
Stop Excel from stripping out leading zeros when saving as CSV 4
Number in text format in CSV file 3

Top