Format serie of numbers
With a formula in another cell.....assuming your data in cell B2
=REPLACE(B2,2,0,0)
"andy62" wrote:
If it's the only "A" in the text you could just use the Replace function, and
replace "A" with "A0"
"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
|