One approach that may work, assuming the data is in A1:C1,

=DATE(2000+C1,MATCH(B1,{"jan","feb","mar","apr","m ay","jun","jul","aug","sep","oct","nov","dec"},0), A1)

"spaceage" wrote:

i want to convert date into normal american style.

i am importing date from text file where
date is coming in this format(in three different column cells).

11 Apr 7

Required result in one column cell 04/11/2007.

can anyone help.


--
rgds