Dave,

You've got it! This phrase contains 2 concepts, which confounds me, and
I've been a software writer/user for 25 years:

Date formats display date and time serial numbers as date values. Except for
items that have an asterisk (*), applied formats do not switch date orders
with
the operating system.

I never understood the serial thing; some columns in my form that have
numbers automatically converted to this serial date concept; for example, an
entry 105 (for a regulation) would display as June 10, 1935. I'm challenged
to overcome that as a separate issue.

The 2nd piece of information (the double negative) could be expressed as:

For items with an asterisk (*), date orders established by the operating
system (see XYZ tab of ABC dialog box) take precedence over Excel settings.




"Dave Peterson" wrote:

Are you positive that the format is mm/dd/yyyy?

If you are, could you try a different format for that column: mm.dd.yyyy

You may have been hit by a coincidence.

When you do Format|cells|Number tab and look at that cell's format, I'm betting
you see something like:

*14/03/2001

That asterisk means that you chose a short date format that is picked up from
the Windows Regional settings (Date tab).

xl2002 is more honest with the way it deals with dates.

At the bottom of that dialog (xl2002):

Date formats display date and time serial numbers as date values. Except for
items that have an asterisk (*), applied formats do not switch date orders with
the operating system.

Since yours is marked with an asterisk, your date will switch formats with the
setting in the OS.

======
If the mm.dd.yyyy worked, try changing your short date in your regional
settings.

=====
You could also give the cells a custom format (just slightly different from the
short date format in regional settings):

"mm/dd/yyyy "
(w/o the quotes, but with the trailing space.)

jenelle wrote:

When enabling the Dim statements, my dates don't work. When disabled, I get a
date, no problem. Wierd thing is that one date is mm/dd/yyyy and the other is
mm-dd-yyyy AND, when they get ported to spread sheet (both formatted as
mm/dd/yyyy date columns), they display in the format 11-Jan-2005.

I added a second line after datInitDate = Date$ as
datInitDate.Value = Format$(datInitDate, "mm/dd/yyyy")
and that took care of the / vs - issue in the form.

The dates display correctly in the formula bar (mm/dd/yyyy), but in the
cells, they are
dd-mmm-yyyy, even though the date columns are ALSO formatted as
mm/dd/yyyy...when I check the format of the added cells they are in the
10-Feb-2001 format.

I'm really lost...any ideas?

--

Dave Peterson