division and decimal points

[Paul K.]

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.

 

[Dave R.]

In the formula bar? Shouldn't you see the formula there? Unless you did this
with a paste special>divide, perhaps.

You can use =ROUND(100/2.4,0) then export as CSV.

 

[Bernard Liengme]

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.

 

[Peo Sjoblom]

Tools>options>calculations 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.]

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.

 

[Paul K.]

Thanks dave I will try the round formula. I used an adjacent cell and paste
special

 

[Dave R.]

Paul, you can use an adjacent cell and paste special, but when you save as
CSV, it converts to values anyway (the value would be 42) and does away with
the formulas that produced the values, so you may be able to save a step.

 

[Paul K.]

Peo
This is exactly what I needed. Thank you.

Paul K.

 

[Paul K.]

Thanks Peo. This is exactly what I need

Paul k.

 

[Paul K.]

I'll try that first Dave, I need to use this function quite often so any
advise is really much appreciated.