No. Definitely NOT a bug. You are misunderstanding the difference between a
cell's VALUE and its display. When you change the format you don't do a
darned thing to the cell's VALUE. It remains 69.5

If you want the rounded value you need to

1) enter the rounded value, or
2) use a formula to round the value =ROUND(69.5.0) and do the Copy/Paste
SpcialValues on the formula.



"D Moran" wrote:

i enter 69.5 in a cell. The i format the cell so there is no decimal places
and the value in the cell is now 70. Now i copy this cell to another one and
paste special - select value. Now it pasts 70 into the new cell but i want to
get rid of the 69.5 in the formula bar accross the top. Is there any way i
can do this ?

I know you can do it if you have a formula and just want to copy the value.
Don't see where you can do it in this case.

Someone please help. Is this a bug in Excel ?