Jump to content

Change the default currency


Recommended Posts

Change the default currency

If your worksheet's formatting conforms to your regional settings, Excel's Currency button makes it easy to format currency values. This button uses settings from the Regional Options dialog box to set the default format. For example, if the Regional Options are set to English (United States), by default, the Currency button formats currency values for the United States.

Follow these steps to change the Currency button's default county/region settings by resetting them in Control Panel:

1. From the Start menu, open Control Panel, and double-click Regional Language And Options if using Windows XP. If you're working with earlier versions of Windows, double-click the Regional Options icon.

2. Select the country/region you want to use as the default from the drop-down Location list, and click OK.

The next time you start Excel, clicking the Currency button will format the cells in the new format.

In earlier versions of Windows, you may need to restart your computer for the changes to take effect. In addition, changing the region in Windows also changes the settings for time, date, and number formats to those used in that region.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...