View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
traveye traveye is offline
external usenet poster
 
Posts: 9
Default 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