Toolsoptionscalculations and precision as displayed (be a bit careful to
make sure you uncheck it later and also that it will change all underlaying
values,
if the formats make them look different)
or use a formula =ROUND(cell_with_41.66667,0)
then paste special as values


Regards,

Peo Sjoblom

"Paul K." wrote:

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.