Locking Formulas/accessing values in Excel??

  • Thread starter Thread starter msullivan78
  • Start date Start date
M

msullivan78

Hi everyone.
I have an excel spreadsheet that takes a text value from a database
using a formula. Now when I double click on this cell so I can edit the
text, it just brings up the forumla itself. Is there anyway I can get
around this so when I double click on the cell I can just edit the
text?
Any help would be much appreciated!!!
 
If a cell contains a formula, you can only edit and change the formula, not
the result returned by the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Damn! Cheers anyway mate!



Chip said:
If a cell contains a formula, you can only edit and change th
formula, not
the result returned by the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.co
Click to expand...
 

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 shows in cell instead of results (text reference) 4
Formula showing in cell 4
Dragging a formula across the row in 2007 2
Pivot Value not formula 4
Pivot value not formula 1
Vlookup - value not formula 1
automatically show cell references of formulas 2
Excel CSV Files; Creating Of 3

Back
Top