Microsoft Office Tutorials and References
In Depth Information
Regional Dating
Adding Different
Types of Data
If you want to fine-tune the settings in your region, click the “Additional settings”
button (in Windows 7), the “Customize this format” button (in Windows Vista), or
the Customize button (in Windows XP). Although the name has changed over the
years, it’s still the same button.
You might decide to customize your region’s settings if you have a particular
preference that doesn’t match the standard options. For example, you might decide that
you want UK-formatted dates on a computer that’s set to use US-region settings for
everything else.
When you customize a region, a new window appears (Figure 14-35) with a long list
of settings.
Figure 14-35:
Tweaking the regional settings on your
computer gives you complete control over how
Excel recognizes dates. Use the drop-down
lists to specify the date separator, order of
month, day, and year components in a date,
and how Excel should interpret two-digit
years. You can mix and match these settings
freely, although you could wind up with a
computer that’s completely counterintuitive
to other people.
Tip: No matter what the regional settings are, you can always use the international date standard
when typing dates into Excel, which is Year/Month/Day, though you must supply a four-digit year (as in
2008/7/4). If you use a two-digit year, Excel assumes you’re trying to use the Month-Day-Year or
DayMonth-Year pattern.
Search JabSto ::

Custom Search