Date Formatting change

P

PaulG

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

Thanks
 
B

Bob Phillips

Select the column, Go to Format>Cells>Custom and input"MM/DD/YY"

--

HTH

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