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?