If you can save the data as a .txt file, you could start a new workbook, then
record a macro when you open the .txt file.

Record your actions as you import each field (choosing the correct date format).

In fact, continue recording when you're adding headers/filters/page setup/etc.

Then save that workbook with the recorded code. Next time you need to import a
similar text file, just open the macro workbook and tools|macro|macros... and
run that macro.



Chris Davidson NGSS wrote:

That was the answer I thought I would get. Can I create a template to use
when I import from the database?

"Peo Sjoblom" wrote:

Unfortunately no, unless you can import the date fields as text

Regards,

Peo Sjoblom

"Chris Davidson NGSS" wrote:

I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

--

Dave Peterson