Most likely your cells have been formatted as text. Reformat as General.
Now press <F2, and then press <Enter That should change it to dd-mm-yyyy,
provided that is how your date format has been set. It might also change it
to dd/mm/yyyy, but it would still be a date.

--
HTH

Kassie

Replace xxx with hotmail


"J.W. Aldridge" wrote:

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