how do i convert the number 1 as 01 or 001 in excell cell

J

JulieD

Hi

you have basically three options:
1) if you want the number to be a number (ie you want to calculate with it
later on) then you'll need to use a custom format, click on the cell, choose
format / cells - under the numbers tab, choose custom, in the white line on
the right hand side type either 00 (to display as 01) or 000 (to display as
001), click OK

if you're happy for the 01 to be treated as text then
2) type '01 or '001 into the cell (note the apostraphe before the 0 - this
makes it text but will not display nor print)
or
3) format the cell as text (format / cells / on the numbers tab choose text)
before typing the 01 or 001 into the cell.

hope this helps
Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top