Simple Question - Cell Padding

[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

 

[Bernard Liengme]

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

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom 000

 

[Jim Berglund]

Thanks, That did it!
Jim

One way:

Format/Cells/Number/Custom 000