I download a query that has a column of dates displayed without the
seperators (20040830). When I try to convert these cells to reflect a date,
nothing changes. No matter what I tell the format to llok like, it remains as
20040830. I can only change this to 2004/08/30 or 30/08/2004 by physically
going in and changing it in each cell.