calculation

[cmccabe]

Hello,

In excel 2010 a formula is set to simply multiply one cell with another. I have set the format to number and no decimal places, but it is making the value in x.xx. So when I use the formula instead of 9*2 = 18 I get 9.33*2 = 19. Any sugestions? Thanks.

 

[kevatarvind]

Try below put value in a1 then use

=left(a1,search(".",a1)-1)*2