Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
Hope you can help me (think it's fairly easy). In column A there's list of numbers (9 characters long). One of our systems requires that the list of numbers (or per number) is preceded by 2 zero's, ie. 12345678 becomes 0012345678. I reckon a cut/copy and paste is a good option but (off course) I'm looking for a piece of programming that changes the numbers into the desired format. Thnx in advance Basta1980 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format date with specific regional format | Excel Worksheet Functions | |||
Specific format | Excel Programming | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
How to specific the cell format? | Excel Worksheet Functions | |||
Add cells with a specific format? | Excel Programming |