| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
save text field w/ leading zeros in .csv format & not lose zeros?
I currently have a csv file with a field that has one digit numbers. I need
to create a text field and convert the one digit number to two digit text by adding a leading zero. I have tried using the concatenate function to add the leading zero, but when I close the csv file, it reverts back to one digit. How can I get the file to save the field as text and include the leading zero? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
| leading zeros in text format | Excel Discussion (Misc queries) | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
Threaded Mode
