Loosing value of large number when saving file to CSV format

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.

Hi,

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

--

Originally Posted by 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.

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.

"Bryan Hessey" wrote:

>
> Hi,
>
> The display format for the cell is probably set to General, rightmouse
> and Format the cell, set it's format to Number.
>
> --
>
> Kim Luu Wrote:
> > 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.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=537690
>
>