| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a formula to a cell containing a constant value
Previous versions of Excel had an "=" sign to the left of the formula bar
(rather than the "fx"). If a cell already contained a constant value, the "=" started a formula beginning with the constant value and took the cursor to the end of the value. Using the "fx" clears out the data in the cell. Is there a way to change the options to allow formulas to be created using the constant already in the cell, similar to the old version? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add a formula to a cell containing a constant value
Why not use the = key?
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Shana77" wrote in message ... Previous versions of Excel had an "=" sign to the left of the formula bar (rather than the "fx"). If a cell already contained a constant value, the "=" started a formula beginning with the constant value and took the cursor to the end of the value. Using the "fx" clears out the data in the cell. Is there a way to change the options to allow formulas to be created using the constant already in the cell, similar to the old version? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add a formula to a cell containing a constant value
Not possible anymore with anything built in, it was either changed in 2002
or 2003 -- Regards, Peo Sjoblom "Shana77" wrote in message ... Previous versions of Excel had an "=" sign to the left of the formula bar (rather than the "fx"). If a cell already contained a constant value, the "=" started a formula beginning with the constant value and took the cursor to the end of the value. Using the "fx" clears out the data in the cell. Is there a way to change the options to allow formulas to be created using the constant already in the cell, similar to the old version? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula won't display as cell set to Constant | Excel Discussion (Misc queries) | |||
| How do I keep one cell constant in a formula even when copying | Excel Discussion (Misc queries) | |||
| How do I set one cell as a constant so I can drag the formula | Excel Discussion (Misc queries) | |||
| keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions | |||
| keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions | |||
Linear Mode
