Ignore leading zeros in a formula cell

[TravEyE]

Ok...heres an example of my problem

cell A1 contains the Letters "right"

Cell B1 contains a formula:

=if(A1="right",.08+.04,.03+.02)

Since the if statement is true Cell B1 returns this value:

0.012

How do I get rid of the zero before the decimal point?

Any help would be appreciated

 

[Dave Peterson]

You could apply a custom format:
Format|Cells|number tab|custom category
..000
or
..00

(but isn't the sum really .12?)

 

[Gary''s Student]

Format > Cells... > Number > Custom > .00