Unable to change date format

[hafeezcloud]

Refer Attachment,

The date is format is MM:DD:YY and i would like to format it to DD:MM:YY and display it as 10-Sep-2012.

Please need your help.

[Ace_XL]

Select your range of data and format cells as

dd-mmm-yyyy

[Kevin UK]

Hi hafeezcloud

You have dates in the column as well as dates as text!

Have a look at this:

[Cutter]

Hello hafeezcloud, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Original thread here: http://www.excelforum.com/excel-gene...-to-hh-mm.html

Thread Closed.