Thread: make 1234 - 012034
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel M[_2_] Daniel M[_2_] is offline
external usenet poster
  
Posts: 12
Default 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.


Reply With QuoteReply With Quote