Excel offers multiple Format cell categories for displaying numbers. Users need to select specific number categories (i.e., Currency, Accounting, or Custom) to display them as Currency. However, aligning those inserted currency symbols requires amounts to be in Accounting, Custom, or aligned Currency format. This article demonstrates the ways to align currency symbols in Excel.
3 Easy Ways to Align Currency Symbol in Excel
Go through the below section to learn more about currency symbol alignment.
Method 1: Using Accounting Number Format to Align Currency Symbol
In the Format Cells (CTRL+1 or click on the Number Format icon) window, there are two dedicated categories (i.e., Currency and Accounting) to display numbers in currencies with currency symbols before them. But displaying numbers in Accounting number format aligns currency symbols to the left.
- Highlight the range or cell then select Accounting as Number Format from the Number Format Display.
- Alternatively, use CTRL+1 to fetch the Format Cells window, and choose Accounting from the Number Category. Assigning numbers as Accounting aligns the currency symbol.
- The outcome of both operations is the same. Excel aligns the currency symbols.
Similar Readings
- How to Align Colon in Excel
- Align Text in Excel
- How to Left Align in Excel
- How to Top Align in Excel
- How to Middle Align in Excel
- How to Bottom Align in Excel
- How to Align Right in Excel
- How to Align Columns in Excel
Method 2: Inserting Custom Number Format in Format Cells Window
In the Format Cells window, users can use Custom number formats by inserting appropriate characters.
- Type the below number format under Type in Format Cells > Custom.
_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)
- The consequences of customizing the number format results in aligning the currency symbol.
Read More: How to Change Alignment in Excel
Method 3: Selecting Preferable Alignment for Aligning Currency Symbol
Numbers in Currency format are displayed with the preferred currency symbol. Aligning them using the Home > Alignment results in the Left, Right, and Center alignment of the currency symbol.
- After displaying the numbers in Currency format align the number Left, Right, or Center using the Alignment section of the Home
- All the alignment options result in the following depiction. Select the Left alignment to align the currency symbol.
Read More: All Types of Alignment in Excel
Download Excel Workbook
Download the attached dataset to practice.
Conclusion
This article demonstrates the ways to align currency symbols in Excel. Selecting the Accounting number format is preferred mostly to align the currency symbols. We hope this article sheds enough light on the alignment of currency symbols.
Related Articles
- How to Apply Center Horizontal Alignment in Excel
- Align Decimal Points in Excel
- Justify Text in Excel
- Default Alignment of Numbers in Excel
- How to Align Numbers in Excel
- Excel VBA to Set Vertical Alignment
- How to Format Cell and Center Text with Excel VBA
- Text Alignment with VBA Command Button in Excel
- [Fixed!] Excel Cell Alignment Not Working
- Excel VBA Horizontal Alignment