In what way is it "not a date"... does it have an apostrophe in front of it
(look in the Formula Bar, not the cell, to see it this is the case) or is
the cell formatted as Text?

--
Rick (MVP - Excel)


"J.W. Aldridge" wrote in message
...
uploaded cell values in column B show as

2009-04-11

(does not read as a date)

Need code that will check to see if any value as above exist in column
B, if so change order to format that reads as a date.

04/11/2009