Format serie of numbers
Assuming your first number is in A1 enter this in B1 and drag down
=LEFT(A1,1)&"0"&+MID(A1,2,7)
"Norm Gregoire" wrote:
I need the following number to look as follows:
Is: A1 D01-3
Want: A01 D01-3
I need to add a zero after the A to 3000 entries without changing the rest.
Can it be done?
Thanks
Norm
|