Need vba code to change date&time stamp as date format dd-mmm-yy in A:A rng

[breadwinner]

Dear experts

I am looking for you help on date&time stamp convert as dateformat in A:A col..i cant use text to column

i want vba code to convert into date format as dd-mmm-yy(01-Aug-14) by click cmd button

find the attachment

thanks alot

[Olly]

Try:

Please Login or Register  to view this content.

[AB33]

Try the attached.