Thread: 4 digits required for a number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sandeep sandeep is offline
external usenet poster
  
Posts: 39
Default 4 digits required for a number
In cell, suppose I have a number 32 & I want it to be in 4 digits like 0032;
for 7-0007; for 200-0200 (It should not change its form from number to Text)
How to write the formula?
Pls help
Reply With QuoteReply With Quote