When you change the number format, you're changing the way that value is
displayed--you're not changing the value in the cell. (You noticed that the
value didn't change in the formula bar.)

There's an option that may work for you--but it affects all the numbers in the
workbook.

Tools|Options|calculation tab|precision as displayed

But be very careful that you really want to lose those "real" values.

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 ?

--

Dave Peterson