Microsoft Office Tutorials and References
In Depth Information
As a consumer or user of a site, you can change your locale settings by following these steps:
Navigate to a site and click the Welcome <your name> link at the top of the page.
Click the My Settings option from the drop-down control.
On the User Information page, click the My Regional Settings link.
On the Regional Settings page, locate the Locale setting. By default, this setting is disabled.
Uncheck the Follow Web Settings check box if you want to make changes and deviate from
the web administrator’s settings for these properties.
The Locale drop-down control provides an extensive list of available locales from which to
choose. Pick the locale that meets your needs.
Click OK to apply your changes to the Regional Settings properties.
Excel Services uses the data culture when formatting numbers, currencies, and dates within a workbook.
As the author of a workbook, you can control rendered formatting of the workbook’s content. When you
are creating the workbook, you can use Excel’s cell formatting features to explicitly set a format and
force Excel Services to render the cell content exactly as you have specified, or implicitly set a format and
then let Excel Services format the content by taking into consideration the data culture of the site where
the workbook is being rendered.
Try It Out Applying Explicit and Implicit Cell Formats
In this exercise, you create a workbook that contains dates and times, and apply a mix of implicit and
explicit formatting to the values in the workbook. Then you load the workbooks on a site first as the
administrator (using the default web settings), and then as yourself (using your own custom locale).
First, create a workbook and publish it to your existing deployment of MOSS as follows:
Start Excel 12 and begin with a blank workbook.
Use the information provided in the following table to populate and format the three cells. The
Value is the information you type in the cell noted in the first column, the Category is the
number formatting to be applied, and the Type is the specific format to be applied. Figure 7-29
shows how Excel displays the workbook in an English environment after the formatting has
*Wednesday, March 14, 2001