Formating from 1 to 01 in excel?

Question

I'm trying to do some number formatting in excel and can't figure out how to do this. I want to convert single digit numbers to double digit numbers. So for example I want to convert the number "7" to "07," "007," or even "0007." Obviously you can do this easily for one or two numbers by hand, but I need to convert 1479 of these. Does anyone know a way to make this formatting happen?

Answer 1

Select all the cells containing the numbers you want to format.

Right-click and select "format cells"

In the first tab 'Numbers' select 'custom'.



In the box at the top left type 00 or 000 or 0000



Then click OK etc.



Now all those cells will show 1 as 01 or 001 or 0001



If you want decimal places you should enter 00.00 or 000.0 or 000000000.0000 or whatever

Answer 2

ok a million is the intro. . This states the optimum theory of your essay, and 3 worry-unfastened helping suggestions. 3 is the three suggestions yet into extra element with the intention to help your substantial ingredient. and a million is stating the three helping suggestions and tying it up right into a end. stable success. and a solid tip for essays, purely fake such as you realize what your speaking approximately, whether you dont. it works each and every of the time.

Answer 3

select a cell containing the numbers you want to format. Do Right Click & choose Format cells. After that in Number Tab choose TEXT & press OK. That s It. You r done. :-)

Answer 4

Thank you very much for tip.

Answer 5

Thank You,