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!

On dec. 14, 13:22, "GC" <gc...@hotmail.com> wrote:
> 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!

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

Use =DATEVALUE(B2 & "/" & A2 & "/" & C2)

"GC" wrote:

> 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!
>
>
> .
>

Thanks Stefi, that worked. Much appreciated.
Gerry

"Stefi" <(E-Mail Removed)> wrote in message
news:e17f28a4-d75c-47f7-88e7-(E-Mail Removed)...
On dec. 14, 13:22, "GC" <gc...@hotmail.com> wrote:
> 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!

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

On dec. 14, 14:41, "GC" <gc...@hotmail.com> wrote:
> Thanks Stefi, that worked. Much appreciated.
> Gerry
>
> "Stefi" <csoszp...@gmail.com> wrote in message
>
> news:e17f28a4-d75c-47f7-88e7-(E-Mail Removed)...
> On dec. 14, 13:22, "GC" <gc...@hotmail.com> wrote:
>
> > 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!
>
> Try
> =DATEVALUE(B2 & "/" & A2 & "/" & C2)
> Regards,
> Stefi

You are welcome! Thanks for the feedback!
Stefi