Formula Problems

Originally Posted by Bryan Hessey

nothing showing, any specific cell that you see this in?

---

I'm not exactly sure what this means.

Originally Posted by Bryan Hessey

note, I presume that you are not referring to (say) Crew07B A44 which shows ='\\Navyblue2\hub\Links\[crew07Milwaukee.xls]Crew07M'!A44 in the fx Formula bar and Rayski/Valdie in the cell ?

---

Hi,

Yes, that is what I'm referring to. The formula should show up in the formula bar, but the value should display in the cell. The problem i'm having, is the value is not displaying in the cell the way it's supposed to. The actual formula is what's displaying in the cell too.

-Barb

Originally Posted by BarbB

I'm not exactly sure what this means.


Hi,

Yes, that is what I'm referring to. The formula should show up in the formula bar, but the value should display in the cell. The problem i'm having, is the value is not displaying in the cell the way it's supposed to. The actual formula is what's displaying in the cell too.

-Barb

Hi,

what cells? - there is nothing amiss with the file that you sent, the formulae show in the Fx Formula bar, the values show in each cell.

Which cells do you see any problem with?

---

Originally Posted by Bryan Hessey

Hi,

what cells? - there is nothing amiss with the file that you sent, the formulae show in the Fx Formula bar, the values show in each cell.

Which cells do you see any problem with?

---

The original file I sent may not have had anything other than the original data. (Sorry)

Anyway, I've re-uploaded the the file. You will see the problem in cell A-18. And if you try to plug any other similar formulas in *any* other cells, you'll end up with the same results.

Thanks

Originally Posted by BarbB

I guess uploading the file would help

Hi,

the format of A18 is TEXT

rightmouse, Format cells, and change to general,
then re-enter the formula.

hth
---

Originally Posted by BarbB

I dont get it. I did that at least a half dozen times last week and all it kept returning was the formula.

But I went ahead and tried it yet again, and now it's working.

Oh well, as long as it's working.

Thanks for all your help!

if you enter a formula and than change the cell to TEXT (A19) it has already resoved, and will display that.

If you re-enter A19 it will give you this same problem, change it back to General too.

The display of the '=' (equals) is usually from a 'text' cell.

---