Thank you to SkipRR above - Changing the Cell format to General stopped the ########## and allowed me to view text.
Ahhhhhh I love Google and helpful peeps. :)