Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
asterisk
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Asterisk in Web Query | Excel Worksheet Functions | |||
How to add asterisk to source data | Charts and Charting in Excel | |||
Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
Finding an asterisk in a cell | Excel Discussion (Misc queries) | |||
Add asterisk to excel cell | Excel Worksheet Functions |