software

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.

--

Kim Luu Wrote:
gt; Currently I tried to save a workbook with field which has value say
gt; 376123456789012 into CSV format. Later on when I tried to load the CSV
gt; file
gt; into Excel, the field is now displayed as 3.76E 14. The content of
gt; this
gt; field is still correct i.e. 376123456789012. Without any modification
gt; to this
gt; file I save it again into CSV format. Once file is saved, I loaded
gt; again into
gt; Excel. This time the field value becomes 376123000000000.
gt;
gt; Can you suggest a way to fix this problem.
gt;
gt; Many thanks in advance.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=537690Thanks 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.

quot;Bryan Hesseyquot; wrote:

gt;
gt; Hi,
gt;
gt; The display format for the cell is probably set to General, rightmouse
gt; and Format the cell, set it's format to Number.
gt;
gt; --
gt;
gt; Kim Luu Wrote:
gt; gt; Currently I tried to save a workbook with field which has value say
gt; gt; 376123456789012 into CSV format. Later on when I tried to load the CSV
gt; gt; file
gt; gt; into Excel, the field is now displayed as 3.76E 14. The content of
gt; gt; this
gt; gt; field is still correct i.e. 376123456789012. Without any modification
gt; gt; to this
gt; gt; file I save it again into CSV format. Once file is saved, I loaded
gt; gt; again into
gt; gt; Excel. This time the field value becomes 376123000000000.
gt; gt;
gt; gt; Can you suggest a way to fix this problem.
gt; gt;
gt; gt; Many thanks in advance.
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=537690
gt;
gt;