Stopping data exported from a database formatting as a date

G

Guest

I am exporting into Excel from a unknown database and the data - in this case
a part number (eg 2-2035) is converting to a date (eg Feb-35). How can I
stop this happening,? The Excel file is automatically created on export and
therefore I cannot pre-format the cells. Neither do I have any control over
the database format.
 
E

Earl Kiosterud

Stephen,

If the exporting program is writing an Excel file, it needs to pre-format
the field (column) for text first. If it's a text file, rename it with the
..txt extension before opening it in Excel, which will start the import
wizard when you open it in Excel, allowing you to pre-format the column for
text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formatting 2
Data being corrupted by excels automatic date recognition re-forma 6
Date columns are formatted incorrectly on export to excel 1
Date Formating Problem 1
Columns formatted As Dates Are Exported as a Number to Text 1
Sum Exported data automatically from Access database 9
Date format getting muddled 3
General Format to Date Format 9

Top