View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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