View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike L. Mike L. is offline
external usenet poster
 
Posts: 1
Default I need to convert a number to text but I need it to be 5 position

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