Select the column, Go to FormatCellsCustom and input"MM/DD/YY"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PaulG" wrote in message
...
I have dates in a column formatted as yyyymmdd. I want to change the
format
to MM/DD/YY.

Thanks