I am using Excel 2008 for Mac (I am also trying to work using the newest version of Excel on my computer, but it keeps crashing).
When I open the spreadsheet that I need to work from, some of the cells seem to contain too many characters, and are converted to "#" symbols:
The data in the cell is supposed to be text with snippets of code (the % symbol appears as well as @ symbols).
I tried expanding the size of the cells, but it didn't change anything. I cannot find much help online about this version of Excel, but following this answer, I decided to ask it here.