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
--
oldLearner57

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
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57

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
on a different pc that uses a different windows date format setting, then you'll
see something different.

tikchye_oldLearner57 wrote:

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
--
oldLearner57

--

Dave Peterson

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
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57

10s Dave F :) much apprecitated
--
oldLearner57


"Dave F" wrote:

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
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57

Martin & Dave Peterson have different interpretations that may be more
accurate.

Dave
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

10s Dave F :) much apprecitated
--
oldLearner57


"Dave F" wrote:

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
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57

thanks Dave Peterson....much appreciated for the explaination
--
oldLearner57


"Dave Peterson" wrote:

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
on a different pc that uses a different windows date format setting, then you'll
see something different.

tikchye_oldLearner57 wrote:

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
--
oldLearner57

--

Dave Peterson

thanks Martin Fishlock ....appreciate your explaination
--
oldLearner57


"Martin Fishlock" wrote:

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
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57