VBA write macro change column with 3 number digits to 4 digits the

James C · Jan 25, 2010

--
James

Jacob Skaria · Jan 25, 2010

Do you mean

Sub Macro()
Range("D1

10").NumberFormat = "0000"
End Sub

Pete_UK · Jan 25, 2010

Use the white space (here) to record details of your requirements -
don't try to put it all in the message header.

Pete

James C · Jan 25, 2010

Thanks for your response
--
James

Jacob Skaria said:
Do you mean

Sub Macro()
Range("D110").NumberFormat = "0000"
End Sub