How to delete cell formats without losing the cell content in Microsoft Excel?

To remove all formatting, select all the cells and select 'Clear formats' from the button present in the editing section of the Home tab. This will convert your data in the cells of worksheet into plain text and allows you to use it for storing or calculating other information.

from http://en.kioskea.net/faq/10707-excel-remove-all-cell-formatting