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

Transform text in date format
 

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

Transform text in date format
 

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