Troubleshoot data formatting

Numbers, dates, and times aren't displayed correctly.

Options you select in the Regional Settings of Control Panel determine the default format for currency, dates, times, and numbers.

To change your regional option setting, do the following:

  1. On the Windows Start menu, point to Settings, click Control Panel, and then click Regional Options.
  2. On the General tab, under Settings for the current user, select the locale of the currency you want to display in the Your locale (location) list.
  3. Click OK.