| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the result of a formula to a real number.
Years ago, probably with Lotus123, I was able to convert a range of cells
that contained a simple formula to its resulting real number. ie. c3 is the formula c1+c2 and displays the number 8 when c1=5 and c2=3. I am hoping there is a way without reentering the number 8 to change c3 to 8. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the result of a formula to a real number.
Hi,
Try, Right click and copy the cells(s) then paste it (them) back over themselves with Edit|Paste special - select values OK Mike "coldindetroit" wrote: Years ago, probably with Lotus123, I was able to convert a range of cells that contained a simple formula to its resulting real number. ie. c3 is the formula c1+c2 and displays the number 8 when c1=5 and c2=3. I am hoping there is a way without reentering the number 8 to change c3 to 8. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the result of a formula to a real number.
Select C3
CopyPaste Special(in place)ValuesOKEsc Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 12:29:02 -0800, coldindetroit wrote: Years ago, probably with Lotus123, I was able to convert a range of cells that contained a simple formula to its resulting real number. ie. c3 is the formula c1+c2 and displays the number 8 when c1=5 and c2=3. I am hoping there is a way without reentering the number 8 to change c3 to 8. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell contents from formula to the actual result | Excel Discussion (Misc queries) | |||
| Formula result as real empty/blank cell | Excel Worksheet Functions | |||
| How can I convert the result of a formula to a whole number? | Excel Discussion (Misc queries) | |||
| Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Linear Mode
