Dates not being recognized as numeric
 

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

Dates not being recognized as numeric
 

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

Dates not being recognized as numeric
 

Thanks. We'll try it.

"Jan Karel Pieterse" wrote:

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