Ignore leading zeros in a formula cell

T

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
 
D

Dave Peterson

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

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

Ask a Question

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.

Ask a Question

Similar Threads

Lookup a particular cell in another excel workbook 1
Date converts to number when part of a formula 3
need formula returning a blank cell 4
Leading Zeros 2
Ignore blank celss in left function 2
Lookup part of a cell's contents and return value of entire cell 2
Array formula to Identify Leading Zeros. 2
cell B1 contains a word listed in cell A1 2

Top