You need to make the Wizard appear. Export from your app as either .csv or
..txt

Then open Excel and:

Data Import External Data Import Data... and point to the .txt file

This forces the Wizard to appear. Tell the Wizard that the field is:
mm/dd/yyyy
--
Gary''s Student - gsnu200836


"Kristi" wrote:

When I export from one system it opens a version of excel, regardless of if i
copy and paste from that excel version or if I import from that version that
date gets flipped
Ex 03/02/2009 gets changed to 2/3/2009

"Gary''s Student" wrote:

Be sure to use the Import Wizard when you import the data. You can tell the
Wizard what the format is.
--
Gary''s Student - gsnu200836


"Kristi" wrote:

When I import a date from an external source, my date month and day get
flipped unless the day is greater than 12 then it reverts to text.
Any suggestions on what to do?