Concatenating 3 text columns into a useable date
 

I have 3 columns each with a text number, e.g. 12, 23, 2008. How can I
concatenate them into a useable date of 12/23/08 (etc)? Thanks!

Concatenating 3 text columns into a useable date
 

Try this:

......A.....B.....C
.....12....23...2008

=DATE(C1,A1,B1)

--
Biff
Microsoft Excel MVP


"EMREMEV" wrote in message
...
I have 3 columns each with a text number, e.g. 12, 23, 2008. How can I
concatenate them into a useable date of 12/23/08 (etc)? Thanks!