G Guest May 21, 2004 #1 HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO DATES WHEN I DO A DATA IMPORT INTO EXCEL?
HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO DATES WHEN I DO A DATA IMPORT INTO EXCEL?
D Don Guillett May 21, 2004 #2 Yell real LOUD. That does it for me. Seriously, please don't use all caps for subject or body of msg. It is considered shouting and rude. Try pre-formatting your destination range to text. -- Don Guillett SalesAid Software (e-mail address removed) TONY said: HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO Click to expand... DATES WHEN I DO A DATA IMPORT INTO EXCEL?
Yell real LOUD. That does it for me. Seriously, please don't use all caps for subject or body of msg. It is considered shouting and rude. Try pre-formatting your destination range to text. -- Don Guillett SalesAid Software (e-mail address removed) TONY said: HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO Click to expand... DATES WHEN I DO A DATA IMPORT INTO EXCEL?
G Gord Dibben May 21, 2004 #3 Tony You could try formatting the cells in Excel to Text before the import. Gord Dibben Excel MVP
G Guest Jun 10, 2004 #4 I can tell you that if you are importing HTML to Excel, changing cell format to Text doesn't work.
