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?