Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Currency Format Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

The Currency Format dialog box enables you to control how numeric values in a column are presented in the PowerPivot window. To access this dialog box, on the Home tab, in the Formatting group, click the currency button.

There are many options for choosing a currency and locale-specific formats. You can also control the number of digits shown in the currency amount by setting the number of decimal places. For more information, see Set the Data Type of a Column.


Displays how numbers in the column will appear when the selected currency formats have been applied.

Decimal places

Click the up arrow to increase the number of places after the decimal separator. The maximum number of decimal places is 15.

Click the down arrow to reduce the number of decimal places. The minimum value is 0.


Click the dropdown list to select a currency symbol and locale from the list.

For example, there are multiple dollar signs, but the dollar sign for each locale is displayed differently depending on international requirements.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft