| 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. |
| 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) | |||
Threaded Mode
