I've been using excel for a number of years now, and this is the first I've
ever seen this happen. Starting today, random parts of my sheets will appear
blank, but if click on the cell, the value will appear in the formula bar.

So say A1 has the word "Example" in it. On the screen the cell will appear
blank, but when I click on the cell, the word "example" appears in the
forumula bar only. I've tried changing font, color, alignment, size of cell
etc. The only thing that works is when I use the format painter. Any help
is very much appreciated. Thanks

Brennan