Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert stored numbers into a set naming convention
I have a list of around 2000 numbers ranging from 3 to six digits. I need to
convert all numbers to six digits with leading zeros is 345 becomes 000345 and 12345 becomes 012345. I also need to convert all of those to a set naming convention with a set prifix letter M and followed by PC001 so 345 becomes M000345PCOO1 AND 12345 BECOMES M012345PC001. All original numbers are stored as numbers on one column Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers stored as text prevent calculations | Excel Worksheet Functions | |||
Numbers stored as text | Excel Discussion (Misc queries) | |||
Convert numbers that have hidden Quotation Mark Embedded | Excel Discussion (Misc queries) | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) |