[SOLVED] make 1234 -> 012034

I have a cell with a 4 digit number that i need to convert to 6 digit with
zeros. Is there a way i can do this in a macro?

I have 1234
I need 012034

thanks.

How about
="0"&LEFT(A1,2)&"0"&RIGHT(A1,2)

In macro, substitute A1 with range

"Daniel M" wrote:

> I have a cell with a 4 digit number that i need to convert to 6 digit with
> zeros. Is there a way i can do this in a macro?
>
> I have 1234
> I need 012034
>
> thanks.
>
>
>