How to delete cell formats without losing the cell content in Microsoft Excel?
Be the first to add this question to starred list!
▼Scroll down for more questions▼
Answers (1)
vote up or down the answers
Answer Link
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
from http://en.kioskea.net/faq/10707-excel-remove-all-cell-formatting
on July 23, 2014