Quote Originally Posted by dwarfman
Quote Originally Posted by AHiltz
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'.
That doesn't work