Date Format as *3/14/2008
Thanks.
"David Biddulph" wrote:
Try this:
Put the formula =TODAY() in 9 or so cells.
Format each of these in turn with the various options from the Format Cells/
Number/ Date options.
In my case the first 2 of these options are the ones that had an asterisk
beside them, with the explanation footnote you quoted.
Now go to the windows Control Panel, Regional Settings, and either change to
a different option, such as changing English US to English UK, or just
change the options for display of long date and short date to some different
formats.
Now go back to your excel spreadsheet and you'll see that the formats which
had the asterisk alongside them have changed to match the new regional
settings options for short & long dates, but the rest of the formats
displayed are unaltered.
Now remember to go back to Regional Settings and put them back to your
normal settings.
--
David Biddulph
"Daren" wrote in message
...
Hello,
If the format for date is *3/14/2008, I get the message at the bottom of
the
Format Cells Box that "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." What does this mean?
Thanks!
|