Transform text in date format

Hello all,

I have this date 12.12.2006 and I would like to transform in a date
format. Is it possible? any suggestion?

Ina

Try this formula:
=DATE(RIGHT(D19,4),MID(D19,4,2),LEFT(D19,2))

Where D19 is the cell where the date is, the modify it as needed.
"ina" wrote:

> Hello all,
>
> I have this date 12.12.2006 and I would like to transform in a date
> format. Is it possible? any suggestion?
>
> Ina
>
>

Michael wrote:
> Try this formula:
> =DATE(RIGHT(D19,4),MID(D19,4,2),LEFT(D19,2))
>
> Where D19 is the cell where the date is, the modify it as needed.
> "ina" wrote:
>
> > Hello all,
> >
> > I have this date 12.12.2006 and I would like to transform in a date
> > format. Is it possible? any suggestion?
> >
> > Ina
> >
> >

Thank you Michael but with vba need I use dateserial, there isn't a
function called date in vba? isn't?

Ina