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.