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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Not possible anymore with anything built in, it was either changed in 2002
or 2003
 
You must log in or register to reply here.

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

Formula vs. Constant 24
Reference array constant values in a formula 2
How do I fix: cell won't calculate because it is a constant? 1
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? 12
Average of a string containing multiple values 20
How to set text color based on value in cell compared to constant 3
how can we make one constant number to be act as variable 3
constant in formulas 3

Back
Top