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