You can edit that formula in that cell by pressing F2 when in the cell.
Then you should be able to read it or copy the formula within that edit box.
Don Marang
--------------------------------------------------
From: "Cliff Smales" <[email protected]>
Sent: Thursday, March 25, 2010 9:40 PM
To: <[email protected]>
Subject: [Blind-Computing] Another Excel problem
Recently, I had some problems that effected my e-mail and, unexpectedly,
my excel.
I had a spreadsheet that I'd been maintaining for several months.
When I opened the spreadsheet, yesterday, I found that all of my data was
splattered all over the sheet, except for one answer to a calculation that
bears the message, "has formula".
If I could open that formula and obtain it's factors singly, I could
reconstruct my spreadsheet. Is there any way to do this?
Clifford Smales
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/