swapping formulas with the value they generate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to swap the formula in a particular cell with the value that
is generated so the formula doesnt show but the value does.
 
Copy then Paste Special Values ... but you can't get the formula back

Regards

Trevor
 
Typically in Excel, the values do show and the formulas do not......except
that the formula shows in the Formula Bar when you highlight a cell that
contains a formula. If your formulas are showing in the cells, something is
wrong.........probably the cell is formatted as TEXT, or does not contain a
leading equal sign, which tells Excel that the entry is indeed a
formula.........

hth
Vaya con Dios,
Chuck, CABGx3
 
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

Scrabble Value calculation for Welsh words 0
Excel Staff Grade and Shift 0
Continue Excel to New Uear 9
Searching the formula (not the value) for a text string 1
Excel VBA 1
value not recognized as a formula 1
Subtotal of values in cells containing formula 1
With F1 value, look at A, if match or partial match return B 5

Back
Top