Please, review topics below to find answer to your question

View | Ignore Formatting menu command

In some cases it is useful to turn of all formatting in the workbook and put your focus into the data.

When you turn ON this option, formatting is not removed from the workbook. But it is not used to display the data. Every cell is displayed without formatting options.