Simple Question - Cell Padding

J

Jim Berglund

I have a set of 20000 numbers , some of which are in one form, some in the
other.

How do I convert a number - like 3, to 003?

Thanks,
Jim Berglund
 
B

Bernard Liengme

Select all the cells; use menu command Format| Format Cells -> Custom Format
and specify 000 as the format
best wishes
 
Top