| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers truncating
The data is there in your csv file, but the problem is if you get Excel to
read in the file with the default extension of csv. If you change the file extension to txt instead of csv, then at the import stage define the column as text format rather than general. -- David Biddulph "Sue" wrote in message ... 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
