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
|