Importing dates with some text

  • Thread starter Thread starter matjcb
  • Start date Start date
M

matjcb

I have a .xls Pread sheet with dates and some data like N/A and PTS

Example

DWG GC Date Eng Date
101-00 12/23/2009 12/25/2009
202-00 N/A 12/23/2009
203-00 12/23/2009 PTS
301-00 N/A 12/23/2009
302-00 12/23/2009 N/A

I would like to import this as data type Short Date with the exeption of
This text type N/A or PTS

Can this be done?
 
Back
Top