Date cell format

A

Avi

Hi experts,

I got an Excel sheet with a text column with a series of digits like
08182005 representing date (mmddyyyy). I tried to use cell format to make
Excel recognize it as date, but I was not successful.
Once Excel recognizes it as date I would like to convert in to the format
(DD/MM/YYYY)

Thanks,
Avi
 
J

JE McGimpsey

If the values are all 8 digits, select the column, choose Data/Text to
Columns..., click Next, Next, and select MDY from the Date dropdown.
Click Finish.

Format as you like.
 
Top