I have app 1500 numbers in col A.some as single digits,others are in the
ten's or hundred's or thousand's such as 1,12,123,4567 etc
I want a maccro that will do as follows:
If col a1 = 1 I want it to look like this "2007 0001"
If col a 1 =12 I wnat it to look like this "2007 0012"
If col A=123, I want it to look like this"2007 0123"
the highest number I have is a four digit number (9999) and that should look
like thsi"2007 9999"
Thanks for any help