date format
 

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

date format
 

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

date format
 

Hi

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

--
Regards

Roger Govier


"spaceage" wrote in message
...
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

date format
 

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

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


"spaceage" wrote in message
...
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