View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default VBA write macro change column with 3 number digits to 4 digits the

Do you mean

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

--
Jacob


"James C" wrote:


--
James