| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove leading zero in xls when converting to csv forfield contain
2 Character columen contains both character and numerics, example 4B and 02.
The 02 is converted to 2 in the CSV file regardless of whether the cell is formatted as general, text, or custom. I also used a value of '02 to identify it as text value and it still converted it. How do I prevent it from removing the leading zero? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REMOVE LEADING ZEROS | Excel Worksheet Functions | |||
| Converting xls to CSV file - dropping leading 0s | Excel Discussion (Misc queries) | |||
| remove leading zero from a string.. | Excel Worksheet Functions | |||
| Remove leading space | Excel Worksheet Functions | |||
| How do I remove leading zero in large DB? | Excel Discussion (Misc queries) | |||
Threaded Mode
