Could it be that those cells are formatted Text instead of General?
--
richjthorpe Wrote:
Hi,
I've created a spreadsheet with multiple workbooks. I've created
another workbook at the beginning and started to make up a Contents
Summary of the other workbooks by using the =Distribution!B3 type
formula.
The issue is that while most formulas work correctly (Bring back the
expected text), there are a couple of cells which only display the
actual formula.
Editting a correctly working formula also has the same affect whereby
the formula is shown but no the result.
What's going on ?
Thanks,
Richie.
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=531842