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?

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?

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?