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

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.


In article <de25mq$kiq$(E-Mail Removed)>, "Avi" <(E-Mail Removed)>
wrote:

> 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