Locking Formulas/accessing values in Excel??

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!!!
 
C

Chip Pearson

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
 
M

msullivan78

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...
 
Top