4 digits required for a number

S

Sandeep

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
 
S

Sheeloo

Select the range you want to show four digits, go to Fomrat Cells, Choose
Custom and in the Type box enter 0000 (that is four zeroes) as the format and
you are set.
 
Top