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.