How do you add zero before values in excel document?
I am trying to edit product codes in Excel so that each product code is exactly 8 digits in length.
Currently the product codes are different lengths, for example:
12 1222 213212 32 3231 3213131
The above codes should read as follows:
00000012 00001222 00213212 00000032 00003231 03213131
As you can see all product codes are now 8 digits in length, any product codes that were less than 8 have had the correct number of 0's prepended to them.
Any help with an Excel formula that would magically do this for me would be appreciated!