| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell from formula to data.
Is there a way to change a cell from a formula (that is returning data) to
the data it is returning. I realy hop it it becuse it would help out a ton. -- Thanks TimM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing cell from formula to data.
If you select the cell and copy then edit - pastes special - values on the
cell you will have the value and not the formula. HTH -- Sincerely, Michael Colvin "TimM" wrote: Is there a way to change a cell from a formula (that is returning data) to the data it is returning. I realy hop it it becuse it would help out a ton. -- Thanks TimM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing cell from formula to data.
Hi,
Select the cell(s) containing the formula(s), "Edit" -- "Copy" -- "Edit" -- "Paste Special" -- "Values" -- "OK". This would change formula results to standalone data. However, please note that the formulas are permanently lost. Regards, B. R. Ramachandran "TimM" wrote: Is there a way to change a cell from a formula (that is returning data) to the data it is returning. I realy hop it it becuse it would help out a ton. -- Thanks TimM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you write an excel formula to sum data in every second cell | Excel Worksheet Functions | |||
| how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions | |||
| how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Formula to Seperate data in 1 cell | Excel Worksheet Functions | |||
Linear Mode
