View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default change values in a column

You could just format the cells to display numbers using a Custom Number
Format of "00".

In VBA code, this would look like the following:

Sub ShowLeadingZeroFormat()
Selection.NumberFormat = "00"
End Sub

--
Regards,
Bill Renaud