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

[James C]

--
James

 

[Jacob Skaria]

Do you mean

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

 

[Pete_UK]

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]

Thanks for your response
--
James

Do you mean

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