Loosing value of large number when saving file to CSV format

K

Kim Luu

Currently I tried to save a workbook with field which has value say
376123456789012 into CSV format. Later on when I tried to load the CSV file
into Excel, the field is now displayed as 3.76E+14. The content of this
field is still correct i.e. 376123456789012. Without any modification to this
file I save it again into CSV format. Once file is saved, I loaded again into
Excel. This time the field value becomes 376123000000000.

Can you suggest a way to fix this problem.

Many thanks in advance.
 
B

Bryan Hessey

Hi,

The display format for the cell is probably set to General, rightmouse
and Format the cell, set it's format to Number.

--
 
K

Kim Luu

Thanks Bryan,

I did that however, as soon as I saved the file as CSV format and reload it
again the format went back to general. It looks like Excel auto default all
cells to General when open CSV file. Is there a way to change the default
value to Text instead of General.

The problem is that I have many customers who are using Excel to populate
data and save the file as CSV before sending it to me. Not all of them are
computing literate (that was why I recommend Excel as the tool for them). To
tell them to write macro for their file is very inconvenient.
 

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

Top