asterisk

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi community

can someone explain why there is an asterisk sign on the top right corner of
the Format on Date format

it was found on the *3/14/2001 & *Wednesday, March 14, 2001

is there any meaning on the asterisk symbol ?

thanks community
 
From the message at the bottom of that dialog window: "Except for items that
have an asterisk, applied formats do not switch date orders with the
operating system."

Of course, that's not really clear. Essentially, Windows and Apple's OSX
use different date formats, and this affects dates in the early 20th century.
See here for more detail than you care to know:
http://www.cpearson.com/excel/datetime.htm

Dave
 
Saved from a previous post.

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

*03/14/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.

=====
So if format your date using one of the formats marked with an asterisk, then
excel will use that pc's windows date format setting. So if you open the file
 
IHi Tikchye:

It explains on the format cells tabe at the bottom. Note very clearly but I
worked out that it is where you have different date settings to US (??) and
the * items will keep them as US dates.

Where as dates without the * use the local settings in my system that it the
buddhist era and Thai dates.

Hopefully somebody else will explain better
 
10s Dave F :) much apprecitated
--
oldLearner57


Dave F said:
From the message at the bottom of that dialog window: "Except for items that
have an asterisk, applied formats do not switch date orders with the
operating system."

Of course, that's not really clear. Essentially, Windows and Apple's OSX
use different date formats, and this affects dates in the early 20th century.
See here for more detail than you care to know:
http://www.cpearson.com/excel/datetime.htm

Dave
Click to expand...
 
Back
Top