I have encountered a problem, where I have several columns of invoice numbers that were entered into Excel. The columns were in Number format and as such a 001125 became 1125.
The field is 12 characters long. I need the macro to go through each record and if the number of characters in the cell is less than 12, to add as many 0 (zeroes) as necessary at the front of the number (which will be in "text" format).
1234 becomes 000000001234
12345678 becomes 000012345678
If anyone can help me write a macro for this, it would be greatly appreciated.
Thanks.
ambra19
The field is 12 characters long. I need the macro to go through each record and if the number of characters in the cell is less than 12, to add as many 0 (zeroes) as necessary at the front of the number (which will be in "text" format).
1234 becomes 000000001234
12345678 becomes 000012345678
If anyone can help me write a macro for this, it would be greatly appreciated.
Thanks.
ambra19