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.


--
richjthorpe
------------------------------------------------------------------------
richjthorpe's Profile: http://www.excelforum.com/member.php...o&userid=33352
View this thread: http://www.excelforum.com/showthread...hreadid=531842

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

It doesn't seem to make a difference.


--
richjthorpe
------------------------------------------------------------------------
richjthorpe's Profile: http://www.excelforum.com/member.php...o&userid=33352
View this thread: http://www.excelforum.com/showthread...hreadid=531842

After you reformat the cell as General (or Number--just not Text)...

select the cell
Hit F2 (to edit the cell)
Hit Enter

Excel will recognize it as a formula.

richjthorpe wrote:

It doesn't seem to make a difference.

--
richjthorpe
------------------------------------------------------------------------
richjthorpe's Profile: http://www.excelforum.com/member.php...o&userid=33352
View this thread: http://www.excelforum.com/showthread...hreadid=531842

--

Dave Peterson

Thanks ! That's been driving me crazy !

Richie.


--
richjthorpe
------------------------------------------------------------------------
richjthorpe's Profile: http://www.excelforum.com/member.php...o&userid=33352
View this thread: http://www.excelforum.com/showthread...hreadid=531842