Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I hope I can explain this well enough to be understood. I have a LONG
column. Each cell in this column contains a formula (=(M331/1000000)+37) which returns a value to the cell. However, when you click on a completed cell, you get the formula in the formula bar. What I would like to do; after I have completed all my data input; is to highlight the cells in this column, and replace the formula with the value in each cell, so that if I want to use this value somewhere else, I copy the value, not the formula. Thanks. -- Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting daily data into weekly, monthly and yearly data | Excel Discussion (Misc queries) | |||
Reformattign Data/Converting-Combinign Vertical Data to Horizontal | Excel Worksheet Functions | |||
Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
Converting Formula Results to Actual Data Values | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |