| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a leading 0 in a csv format?
Hello, I receive data from our geologist from a program that drops the
leading 0 from the API #'s for different wells. I need/have to restore this 0 in order to do imports into the software I use. So I have a #: 11256094 that should read: 011256094 I have tried using the concatonate function sucessfully in excel (setting up a '0 in one cell and the 11256094 in another cell), but when I save it as a csv file, it drops the lead zero. I've reformatted my cells to text, but this is still not helping solve this problem. Any help will be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
| How to save worksheet in .cvs format? | Excel Discussion (Misc queries) | |||
| cannot edit and save | New Users to Excel | |||
| cannot edit and save | Excel Discussion (Misc queries) | |||
| How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
Threaded Mode
