copy cell value not contents

D

D Moran

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 ?
 
D

Dave Peterson

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

Duke Carey

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
Spcial>Values on the formula.
 
Top