Thanks Peo. This is exactly what I need
Paul k.
"Peo Sjoblom" wrote:
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.
|