Thread: Dates not being recognized as numeric
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default 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

Reply With QuoteReply With Quote