Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e

S

Safi

Hi,
How to Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in excel.

Will any body help in sorting this prblm..
 
T

Toppers

=TEXT(DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)),"dd-mmm-yyyy")

assuming input format is always dd.mm.yyyy

HTH
 
Top