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