| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to add character before leading zero in a field
I need an automated way to add a character before a leading zero in a field.
I am importing information into excel from one software, manipulating the information so I have only what I need and then exporting the information into another software. We created a macro to keep the leading zero in Excel but the software we are importing the information into does not allow leading zeros. =( So we have to add a character to before the leading zero. I am currently using Excel 2003. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a field in Excel to allow for leading zeros? | Excel Discussion (Misc queries) | |||
| Leading zeroes in ZIP field | Excel Discussion (Misc queries) | |||
| How do I force a leading zero character eg 07817 | Excel Discussion (Misc queries) | |||
| How can I prefill a text field with leading 0s? | Excel Worksheet Functions | |||
| How to keep leading zero without changing field to text field? | Excel Discussion (Misc queries) | |||
Threaded Mode
