Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell value not contents
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell value not contents
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell value not contents
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |