Thread: convert number to text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default convert number to text
format([a1],"000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Scott" wrote in message ...
| how to convert a number to text in vba, e.g. showing 5 as "005". I can do it
| on spreadsheet with a function like '=Text(A1,"000")'. can it be done in vba?


Reply With QuoteReply With Quote