How do I add a formula to a cell containing a constant value

G

Guest

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?
 
P

Peo Sjoblom

Not possible anymore with anything built in, it was either changed in 2002
or 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference array constant values in a formula 2
Formula vs. Constant 24
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? 12
How to set text color based on value in cell compared to constant 3
How do I fix: cell won't calculate because it is a constant? 1
Formula won't display as cell set to Constant 1
Value used in a Paste Link to remain constant during a sort 1
how can we make one constant number to be act as variable 3

Top