Forum Discussion
Formulas displaying as text
Can anyone tell me why my worksheet allows me to type in formulas one minute but then suddenly starts to display the formulas as text and won't do the calculations?
Thank you Niko,
It was item 3 that fixed it for me. I had been using a keyboard that very ocasionallly switches modes (HP laptop), in particular the tab key does wierd stuff and it had somehow activated 'Show Formulas'.
Your answers saved me a lot of work looking for a solution to a problem that it was difficult to describe with accurate search terms!
I appreciate your time.
