Another difference...

Say we have a workbook that we have to share. Both of us use the mdy order for
our dates.

But you have your windows shortdate settings to use m/d/yy (1 or 2 digits, 1 or
2 digits, 2 digits).

And I have that setting for mm/dd/yyyy (2 digits, 2 digits, 4 digits).

You enter a bunch of dates in column A and autofit the column to make it pretty.

You send the workbook to me and I open it up and I see #######'s in column A.
That columnwidth isn't wide enough for all 10 of my characters!

So I have to widen the column or change the fontsize or something to see those
dates.

It's not a big deal until you protect that worksheet with a password -- and I
don't know the password!

Then it becomes a real pain for the sender (you!). You'll be getting phone
calls about why you broke the computer!



Daren wrote:

Hello,

If the format for date is *3/14/2008, I get the message at the bottom of the
Format Cells Box that "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." What does this mean?

Thanks!

--

Dave Peterson