converting numbers to date format

  • Thread starter Thread starter GC
  • Start date Start date
G

GC

Hello,
I have 3 columns in a worksheet that contain a number that represents the
date and the other column has a number that represents the month and the
last is the year as a single digit. (A2=14, B2=12, C2=9) The 3 columns are
formated number with 0 decimal. I have a 4th column that is formated date.
(3/14/01). In this 4th column i have =B2 & "/" & A2 & "/" & C2. The result
is 14/12/9 and does not seem to be a date format. I suspect it is a string.
What do I have to do to convert this to date?

Cheers!
 
Hello,
I have 3 columns in a worksheet that contain a number that represents the
date and the other column has a number that represents the month and the
last is the year as a single digit. (A2=14, B2=12, C2=9) The 3 columns are
formated number with 0 decimal. I have a 4th column that is formated date..
(3/14/01). In this 4th column i have  =B2 & "/" & A2 & "/" & C2. The result
is 14/12/9 and does not seem to be a date format. I suspect it is a string.
What do I have to do to convert this to date?

Cheers!
Click to expand...

Try
=DATEVALUE(B2 & "/" & A2 & "/" & C2)
Regards,
Stefi
 
Thanks Stefi, that worked. Much appreciated.
Gerry

Hello,
I have 3 columns in a worksheet that contain a number that represents the
date and the other column has a number that represents the month and the
last is the year as a single digit. (A2=14, B2=12, C2=9) The 3 columns are
formated number with 0 decimal. I have a 4th column that is formated date.
(3/14/01). In this 4th column i have =B2 & "/" & A2 & "/" & C2. The result
is 14/12/9 and does not seem to be a date format. I suspect it is a
string.
What do I have to do to convert this to date?

Cheers!
Click to expand...

Try
=DATEVALUE(B2 & "/" & A2 & "/" & C2)
Regards,
Stefi
 
Back
Top