| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatted numbers to CSV problem
Hi.
There is a file that we want to export to a CSV file, but it is changing the format of things that look like numbers. It should export some of the numbers in a 5 digit format... 01000 , 01001 , etc. We tried changing the cell format to text, and using the formula =text(a1,"00000") and changing that to values... Either way, in the .CSV file, it still came out as 1000 , 1001 . For now, I did what was needed by creating a simple text file with the output. But, is there anyway to keep the leading 0 s on things that look like numbers, in a CSV file? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers formatted as text | Excel Discussion (Misc queries) | |||
| formatted numbers displayed as ##### | New Users to Excel | |||
| Sorting formatted numbers | Excel Discussion (Misc queries) | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| importing large numbers to vb results in the numbers being formatted to scientific | Excel Programming | |||
Threaded Mode
