Formula Problems

**BarbB** · 12-29-2006, 12:02 PM

Originally Posted by Bryan Hessey

Hi,

If you have copied a formula from a working cell to that one, ( ie =A1+A2 ) where A1 & A2 have numbers, and you get the answer, and copy to that cell and it just shows the formula, then I guess:

Edit, Move or Copy Sheet, Make a Copy and copy to a new book

If the problem still exists, remove all of your secret data etc, and post that sheet here as a .zip (in MyComputer, rightmouse and Add to Archive, as a .zip)

---

Yes, I already did these things (two and three times to be sure). Even when I put them in the same Excel file (different tabs) it still does the same thing. This combined file is what I'm uploading.

I dont know how this will display for you since there are other formulas on each sheet that you may not display properly for you.

Thanks so much for your help!

**Bryan Hessey** · 12-31-2006, 03:30 AM

Originally Posted by BarbB

Yes, I already did these things (two and three times to be sure). Even when I put them in the same Excel file (different tabs) it still does the same thing. This combined file is what I'm uploading.

I dont know how this will display for you since there are other formulas on each sheet that you may not display properly for you.

Thanks so much for your help!

Hi,

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

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

---

**arthurbr** · 12-31-2006, 07:09 AM

Select the offending cell(s)
Format as number
Put your cursor in the formula bar
Ctrl+Enter

**BarbB** · 01-02-2007, 11:06 AM

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

**Bryan Hessey** · 01-02-2007, 12:03 PM

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?

---

**BarbB** · 01-02-2007, 12:18 PM

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

**BarbB** · 01-02-2007, 12:26 PM

Originally Posted by BarbB

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

I guess uploading the file would help