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.
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.
