'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Use Currency Format Instead of Accounting in Excel
Question details
Users want to change the default behavior of the dollar sign Ribbon button to apply Currency format instead of Accounting format.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Formatting cells with financial data where the currency symbol needs to be placed directly next to the number rather than aligned to the left edge of the cell.
- Observed behavior
- Excel's default dollar-format button always applies the Accounting format, and there is no built-in application preference to change this specific button's default behavior to Currency.
Since Excel does not allow you to change the native dollar button, ensure the Developer tab is enabled in your Ribbon so you can record a custom formatting macro.
Use the Built-in Keyboard Shortcut
The fastest way to apply the Currency format without clicking any buttons is to use Excel's native keyboard shortcut.
Highlight the cell or range of cells containing the numbers you want to format.
Press Ctrl + Shift + 4 (also known as Ctrl + Shift + $) on your keyboard. This instantly applies the standard Currency format to your selected cells.
Create a Custom Macro and Add it to the Toolbar
Record a quick macro that applies the Currency format and pin it to your Quick Access Toolbar as a replacement for the default dollar button.
Experience Flexible Data Formatting with WPS Office
If Excel's rigid default settings are slowing down your workflow, try WPS Spreadsheet. It offers a free, lightweight, and highly customizable alternative with familiar formatting tools and full macro support to streamline your financial tasks.
- 1. Download and Install: Download WPS Office for free from the official website and run the quick installation.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and seamlessly open any existing Excel files.
- 3. Format Data Easily: Select your cells, right-click to choose 'Format Cells', and easily apply your preferred Currency formatting.
Frequently Asked Questions
What is the difference between Currency and Accounting formats in Excel?
The Accounting format aligns the currency symbol to the far left of the cell, aligns decimal points vertically, and displays zero values as dashes. The Currency format places the currency symbol directly next to the first digit of the number and displays zero values as standard numbers.
Can I remove the default dollar button from the Excel Ribbon?
You cannot remove individual commands from Excel's built-in groups. However, you can hide the entire 'Number' group by going to File > Options > Customize Ribbon, and then create a new custom group containing only the buttons you prefer.
How do I enable the Developer tab to record macros?
Go to File > Options > Customize Ribbon. In the right-hand list of Main Tabs, check the box next to 'Developer', then click OK. The Developer tab will now appear on your Ribbon.
