| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep leading zero in number (Column also contains text)
I have a column with different product ID
Some of the prodID are all text, some are mixed text & num and some are numbers only. I formatted the column to text and fixed everything manually. The data comes from an external source - When I refresh the data some of the data from the provider have leading zero and some don't and it's breaking my lookups. Is it possible to have a macro check each cell in the column (B) Even though column is formatted as text I want to: If value is all numeric and does not start with zero add zero otherwise do nothing. So if my data looks like this 014-07899-00E 014-W7599-TRE 015-40649-A 01553 01559 01561 100384 100443 100519 100537 I'd like it to look like this 014-07899-00E 014-W7599-TRE 015-40649-A 01553 01559 01561 0100384 0100443 0100519 0100537 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros when uploading a number from text file | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| creating a text record from a number preserving the leading zero | Excel Programming | |||
| Number to text with leading zero | Excel Programming | |||
| Force a Number to be Formatted as Text (keep leading 0's) | Excel Programming | |||
Threaded Mode
