View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GKW in GA GKW in GA is offline
external usenet poster
 
Posts: 68
Default Padding with leading zeros

How can I get a column of numbers to appear as 3 positions alpha with leading
zeros as needed

e.g.

1 appears as 001
2 appears as 002
99 apears as 099
999 apears as 999