Thread: I need to convert a number to text but I need it to be 5 position
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown Gary Brown is offline
external usenet poster
  
Posts: 178
Default I need to convert a number to text but I need it to be 5 position
=TEXT(A1,"00000")

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Mike L." wrote:

I need to convert a number to text but it needs to be 5 positions. For
example of the number is 100, I need the text value to be 00100.

Any Ideas
Reply With QuoteReply With Quote