Displaying Formulas in Cells

d-alan · Mar 27th, 2002, 07:34 AM

This should be easy. I am fairly new to the ability of excel, been using it for way too long not to know its power. Anyways, this forum has been a great help, kudos.
My problem is, I have a sheet in which i poulated with information form another workbook in this form.
=[logs.xls]salesloghidden!R2C3
I do this for about 20 cells in different areas of the sheet.
Half of the time the cell displays the correct information, the other half it displays THE FORMULA. I think I have tried everything, even if I put =a3 in one of these cells it displays =a3. What gives. What is the little detail I am missing.
Thanks in advance.

Anne Troy · Mar 27th, 2002, 08:15 AM

The cells that are showing the formula are formatted as text. You may need to select those rows/columns/cell, hit Edit-clear-formatting or All. Then re-enter the formula if necessary.

d-alan · Mar 27th, 2002, 08:23 AM

[ This Message was edited by: d-alan on 2002-03-27 08:04 ]

d-alan · Mar 27th, 2002, 08:35 AM

[ This Message was edited by: d-alan on 2002-03-27 08:05 ]

d-alan · Mar 27th, 2002, 09:04 AM

It is all working now. It was the format issue, I formatted all problematic cells to general and now it is ok.
Thanks for your help.

Mar 27th, 2002, 08:15 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	The cells that are showing the formula are formatted as text. You may need to select those rows/columns/cell, hit Edit-clear-formatting or All. Then re-enter the formula if necessary. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 07:34 AM	#1
d-alan Board Regular Join Date: Mar 2002 Posts: 119	This should be easy. I am fairly new to the ability of excel, been using it for way too long not to know its power. Anyways, this forum has been a great help, kudos. My problem is, I have a sheet in which i poulated with information form another workbook in this form. =[logs.xls]salesloghidden!R2C3 I do this for about 20 cells in different areas of the sheet. Half of the time the cell displays the correct information, the other half it displays THE FORMULA. I think I have tried everything, even if I put =a3 in one of these cells it displays =a3. What gives. What is the little detail I am missing. Thanks in advance.

Mar 27th, 2002, 08:23 AM	#3
d-alan Board Regular Join Date: Mar 2002 Posts: 119	[ This Message was edited by: d-alan on 2002-03-27 08:04 ]

Mar 27th, 2002, 08:35 AM	#4
d-alan Board Regular Join Date: Mar 2002 Posts: 119	[ This Message was edited by: d-alan on 2002-03-27 08:05 ]

Mar 27th, 2002, 09:04 AM	#5
d-alan Board Regular Join Date: Mar 2002 Posts: 119	It is all working now. It was the format issue, I formatted all problematic cells to general and now it is ok. Thanks for your help.