Thread: VBA write macro change column with 3 number digits to 4 digits the
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
James C[_2_] James C[_2_] is offline
external usenet poster
  
Posts: 17
Default VBA write macro change column with 3 number digits to 4 digits
Thanks for your response
--
James


"Jacob Skaria" wrote:

Do you mean

Sub Macro()
Range("D1:D10").NumberFormat = "0000"
End Sub

--
Jacob


"James C" wrote:


--
James
Reply With QuoteReply With Quote