Formatting Dates from Text to Numbers

I receive data daily with dates in the following formats: dd/mm/yyyy,
d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs.
numbers.

Regardless I use text to columns, to separate the values into three columns.
Then I use =date(year, month, day), actually =date(a2,b2,c2) to populate the
date in one field. Does anyone have any suggestions as to how to do this
better or faster?

Thanks,

Tommy

You can use the Text to Columns Wizard to convert the dates


Wizard'.


your data is ('DMY')

of your computer.



"Tommy" wrote:

> I receive data daily with dates in the following formats: dd/mm/yyyy,
> d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs.
> numbers.
>
> Regardless I use text to columns, to separate the values into three columns.
> Then I use =date(year, month, day), actually =date(a2,b2,c2) to populate the
> date in one field. Does anyone have any suggestions as to how to do this
> better or faster?
>
> Thanks,
>
> Tommy