Forum Discussion
hyperlink not showing correctly
I used a program to generate hyperlinks in Excel using =HYPERLINK("location", "text to show"). Strangely when opened in Excel, they all show as the full code of text instead of the "text to show" wit...
Possibly 'Show Formulas' is enabled or the cells are formatted as Text so the formulas won't evaluate.
Patrick2788 Thanks for the suggestion. I just tried turning "Show Formulas" on and off. I could see all the corrected ones showing hyperlink formula when it's on and back to text with link after turning off, but it does not affect other cells that I've not clicked on to correct them.