Ignore leading zeros in a formula cell
 

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

Ignore leading zeros in a formula cell
 

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

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

TravEyE wrote:

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

Ignore leading zeros in a formula cell
 

Format Cells... Number Custom .00
--
Gary''s Student - gsnu200766