How to add a zero infront of a number

[Guest]

How do I add a zero infront of a number.

For example I want the number to be read like this:

012

But i type in excel it shows up as 12.

 

[Guest]

CYNTHIA

Place an apostrophe first then your number (the apostrophe will not show on
the sheet but will be seen in the formula bar), or formate the cell as text.

Mike Rogers

 

[Guest]

Try Format Cells -> Custom. Enter 000.

 

[Stephen]

How do I add a zero infront of a number.

For example I want the number to be read like this:

012

But i type in excel it shows up as 12.

If what you want is always to display three digits (with any necessary
leading digits showing zero), format the cell as 000.

 

[Guest]

select the cells and go to format cells(ctrl+1) and select "number" tab
select the custom.
give 000 in "type" option box.

 

[David Biddulph]

Either format the cell as text before you enter the number, or
Format the cell as 000 if you want it to be 3 digits, or
Use a helper column with the formula ="0"&A1

The 1st & 3rd suggestions leave the cell as text, so you couldn't use it for
calculations; the 2nd would still be a number.

 

[Guest]

Thank you for your help it worked.

select the cells and go to format cells(ctrl+1) and select "number" tab
select the custom.
give 000 in "type" option box.

 

[CYNTHIA]

this is fast and works

CYNTHIA

Place an apostrophe first then your number (the apostrophe will not show on
the sheet but will be seen in the formula bar), or formate the cell as text.

Mike Rogers

 

[RobN]

But if you want it to still behave as numeric, you could apply the custom
format of "0"0 to those cells.

Rob

 

[CYNTHIA]

Thanks for your help.

But if you want it to still behave as numeric, you could apply the custom
format of "0"0 to those cells.

Rob

 

[Mike Rogers]

CYNTHIA

Glad you got it sorted out, thanks for the feed back!!

Mike Rogers