Clear all formats

To clear all the formats for a cell or a range select the cell/range and press in sequence Alt H E F don’t hold the keys down.

All the formats will be removed.

If you need to see the underlying number for a date this is an easy way to find it.