I received an excel file that was converted from several text files.
When trying to sort and vreate pivot tables it would not allow me to
group the data by date. I reviewed all the data and found some cells
in the date field were numbers such as 12/31/05 but others were
reflected as 365268. Any ideas of how to convert to enable grouping?

Thanks!