Use the function TEXT to change the number 2 into the string 0001. That's all.
Here's some info: http://www.techonthenet.com/excel/formulas/text.php
All you've got to do yourself: find the right format for 4 digits. Not too difficult, I'd say.
I'm currently working on a spread sheet to create labels for our facility. The numbers are alphanumeric and may or may not contain leading zero's within the numeric part.
Numbers that may be used:
I've been able to make these count correctly with the following formula (if cell A1 is the base number):
So, it's made that all I have to do is change the label of AAAA1000 and all of the cells that follow will change. However, if I used the label AAAA0001, the next cells change to AAAA2,AAAA3 respectively. Would anyone know how I can modify my formula to check for and include leading 0's?
Additionally, is there a way to check for a difference in the number? That being that the formula uses (A2,4) but sometimes I have a label that is AAAA100 (only 3 numbers).
Note that I can't use a simply drag and fill as there is other information in cells between the number cells.
Any help is greatly appreciated.