date format

[spaceage]

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.

 

[JMB]

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

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

 

[Roger Govier]

Hi

Try
=(A1&B1&C1)+0
Format the cell with the Date layout you want

 

[JMB]

Short, sweet, and to the point. Very nice.

Hi

Try
=(A1&B1&C1)+0
Format the cell with the Date layout you want