Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loosing value of large number when saving file to CSV format
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loosing value of large number when saving file to CSV format
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How to format a number cell to auto count 1 up on file open | Excel Worksheet Functions | |||
Issues with saving text file | Excel Worksheet Functions | |||
number format | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) |