| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers truncating
I have exported a file as a .csv file and when I open it in Excel the numbers
truncate ( I think that's what they're doing) ex. 5193571568 chages to 5.195E+09. I have changed the formatting of the column to text and it still happens. It looks fine if I expand the column but the problem is when I save the file, it automatically shrinks again when I save as a csv file. Any suggestions how to keep the numbers? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Worksheet Functions | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Truncating numbers | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
