Excel question

[Staresy]

My boss has a spreadsheet that has data such as 10.28.2006 that is supposed to be a date, but Excel doesn't recognize it as such. Is there an easy way to convert these values over to a recognized format?

Highlight said cells. Right click on any highlighted cell. Click 'Format Cells'. 'Number' tab. Click 'Date'. Select the format you want the date to be displayed in. Click 'OK'.

I think this is right, although you would have to make sure that the format was mm/dd/yyyy, as I think the default would be dd/mm/yyyy