| 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 ? |
| 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 | |||
Threaded Mode
