Office for Mac Issues

How to Add Accounting Number Format to Excel Quick Access Toolbar on Mac

WPS Content Manager Oct 1, 2026 869 views

Question details

The user needs to add the Accounting Number Format command to the Quick Access Toolbar in Excel for Mac, but the standard command matching the Windows version does not work.

How to Add Accounting Number Format to Excel Quick Access Toolbar on Mac

Product: Excel for Mac
Device & OS: Mac
Scenario: Customizing the Quick Access Toolbar to quickly apply accounting and currency formats to spreadsheet cells.
Observed behavior: Adding the singular '$ Accounting Number Format' command fails to function correctly on macOS. The interface displays duplicate commands, causing confusion over which one actually applies the format.

Before you start

Ensure you have saved your current workbook. Customizing the Quick Access Toolbar modifies application-wide preferences, so updating to the latest version of Excel for Mac is also recommended to prevent interface bugs.

Solution 1Recommended

Select the Correct Accounting Number Formats Command

Choose the plural '$ Accounting Number Formats' command when customizing the toolbar to ensure full compatibility with macOS.

Excel for Mac features two very similar commands in its customization menu: '$ Accounting Number Format' and '$ Accounting Number Formats'. The first command is often ported directly from Windows and fails to work on a Mac. The second (plural) command is natively built for Mac and includes a functioning drop-down menu for multiple currencies.

Open More Commands

Click the down arrow at the far right of the Excel Quick Access Toolbar, then select 'More Commands...' from the drop-down menu.

View All Commands

In the Ribbon & Toolbar preferences window, click the 'Choose commands from' drop-down list and change it from 'Popular Commands' to 'All Commands'.

Locate the Plural Command

Scroll down the alphabetical list to find the commands starting with the dollar sign. Carefully identify '$ Accounting Number Formats' (ensure it has an 's' at the end).

Add to Toolbar

Select '$ Accounting Number Formats' and click the right arrow (>) button to add it to your Quick Access Toolbar list. Click 'Save' and close the preferences window.

Select the Correct Accounting Number Formats Command

Command Variation: The correct command includes both a main button for standard accounting formatting and a drop-down arrow for additional currency variations.

Free Microsoft Office alternative

Use WPS Office for a Bug-Free Mac Spreadsheet Experience

If you are tired of confusing interface quirks and duplicate broken commands in Microsoft Excel for Mac, switch to WPS Office. It provides a clean, intuitive, and highly compatible spreadsheet experience where formatting numbers and currencies works flawlessly on the first try.

1. Open Your Spreadsheet in WPS Office: Launch WPS Spreadsheets on your Mac and open your existing Excel file.
2. Select Cells: Highlight the range of cells you wish to format with accounting data.
3. Apply Accounting Format: Navigate to the Home tab and click the Accounting Number Format drop-down directly on the ribbon to instantly apply your desired currency style.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Intuitive Ribbon interface that works smoothly and natively on macOS.Apply accounting and currency formats with a single, reliable click without digging through settings.Lightweight application that runs fast and saves valuable storage space on your Mac.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the '$ Accounting Number Format' command not work on Excel for Mac?

Excel for Mac occasionally contains legacy or cross-platform commands that don't execute properly on macOS. The singular command is meant for Windows, while the plural '$ Accounting Number Formats' is the functioning command designed specifically for the Mac interface.

How do I remove the broken accounting format button from my Quick Access Toolbar?

Click the down arrow at the end of the Quick Access Toolbar, choose 'More Commands...', select the broken command from the right-hand column, and click the left arrow (<) or minus (-) button to remove it. Finally, click Save.

Can I customize the currency symbol in the Accounting Number Formats drop-down on Mac?

Yes. Once you add the correct '$ Accounting Number Formats' command, clicking its drop-down arrow on the Quick Access Toolbar allows you to choose different default currency symbols such as USD, EUR, or GBP.

Office App Problems