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

"Dave R." wrote:

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." wrote in message
...
Thanks dave I will try the round formula. I used an adjacent cell and
paste
special

"Dave R." wrote:

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

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



"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.