In place of =A1*B1 use =ROUND(A1*B1,0) to round the result to zero decimal
places

Formatting changes what is seen - but not the underlying stored value.
The Formula bar displays the actual stored value.


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul K." wrote in message
...
When I divide 100 by 2.4 my answer is this 41.66666667
By formating the cell to 0 decimal points I get 42
How do I achieve 42 in the formula bar and not 41.666666666667

I need this because I am converting to a csv file to import and sometimes
the import shows the formula bar data rather than the cell formatted data.