Dates not being recognized as numeric

[Guest]

I'm assisting someone with a workbook and I believe that the source of the
dates is a download from another source. In any case, some of the dates are
seen as dates and some are seen as text. Can someone explain what's going
on and what we need to do so that its not a problem again. I'm guessing
we'll need a short macro to clean up the dates.

Thanks,
Barb Reinhardt

 

[Jan Karel Pieterse]

Hi Barb,

I'm guessing
we'll need a short macro to clean up the dates.

Data, text to columns, fixed width, finish.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Guest]

Thanks. We'll try it.

Hi Barb,


Data, text to columns, fixed width, finish.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com