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?
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?