I've got an excel worksheet that contains (string) cell values like this
=-L =-N =-R
Now, excel sees the "=" character and attempts to evaluate the expression. It cannot, and displays the following instead.
I would like the actual string "=-L" to be displayed instead.
I attempted to highlight the entire column and do
right click --> format cells --> Text --> OK
But the column didn't automatically update. I still see
where I should now be seeing
Now... if I double click the cell and then navigate elsewhere, it looks like the text value that is being displayed updates. However, I want the entire workbook to update so that I don't need to go through the hundreds of cells double clicking. I tried
F9 Shift + F9 ctrl + alt + Shift + F9 ctrl + alt + F9
Is there a way this can be done?