LinkBack URL
About LinkBacks
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?
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?
Perhaps you have set the Tools...Options....View....Formulas option?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
CTRL + T will show the formula instead of the result.
CTR: + T will show the result is there is a formula shown.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I was having that same problem today. Right Click the cell --> Format Cell --> General
Then click in the cell and press Enter
Thanks for the suggestions, but none of that has taken care of the problem.
Is there perhaps a label ' marker at the beginning.
Failing that I suggest you upload the workbook.
Regards
How would I upload the workbook?
Thanks again
Nevermind, found out how.
Copy of Baldwin League.xlsx
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.
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.
Thank you so much!
Great, glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks