Referencing another sheet within a workbook

[rwbaldwin0728]

I have the formula: ='Team Scores'!B184
Instead of showing the name that is in that cell, all I see is this same formula.
Ideas?

[Richard Buttrey]

Perhaps you have set the Tools...Options....View....Formulas option?

[oeldere]

CTRL + T will show the formula instead of the result.

CTR: + T will show the result is there is a formula shown.

[majosum]

I was having that same problem today. Right Click the cell --> Format Cell --> General
Then click in the cell and press Enter

[rwbaldwin0728]

Thanks for the suggestions, but none of that has taken care of the problem.

[Richard Buttrey]

Is there perhaps a label ' marker at the beginning.

Failing that I suggest you upload the workbook.

Regards

[rwbaldwin0728]

Nevermind, found out how.
Copy of Baldwin League.xlsx

[rwbaldwin0728]

How would I upload the workbook?
Thanks again

[rwbaldwin0728]

The problem I'm referencing is on the Individual Scores sheet. It needs to pull data from Team Scores. It does for most, but not for a few.

[Jonmo1]

The problematic cells are formatted as TEXT.
They need to be formatted as General.
And the critical step is to RE-Enter the formula after changing the format to General.

[rwbaldwin0728]

Thank you so much!

[Jonmo1]

Great, glad to help.