Thread: I need to convert a number to text but I need it to be 5 position
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
  
Posts: 320
Default I need to convert a number to text but I need it to be 5 position
Format/Cells/Custom tab, enter 00000
Bob Umlas
Excel MVP

"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