AUTO DATE RECOGNITION

T

TONY

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

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
[email protected]
TONY said:
HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO
DATES WHEN I DO A DATA IMPORT INTO EXCEL?
 
G

Gord Dibben

Tony

You could try formatting the cells in Excel to Text before the import.

Gord Dibben Excel MVP
 
A

alex

I can tell you that if you are importing HTML to Excel, changing cell format to Text doesn't work.
 
Top