Excel 2003 Formula Issue
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 |
Excel 2003 Formula Issue
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 |
Excel 2003 Formula Issue
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 |
Excel 2003 Formula Issue
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 |
Excel 2003 Formula Issue
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 |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com