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 Cvt number to character

Hiow can I convert a column of numbers from numeric to character and pad with
2 zeros

e.g. I want the number 1 to appear as character 001