Thread: Cvt number to character
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
  
Posts: 1,397
Default Cvt number to character
=text(A1,"000")

"GKW in GA" wrote:

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
Reply With QuoteReply With Quote