How to Align Currency Symbol in Excel: 3 Easy Ways

Method 1 – Using Accounting Number Format to Align Currency Symbol

  • Highlight the range or cell then select Accounting as Number Format from the Number Format Display.

Number Format-Accounting

  • 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.

⧭Note: Selecting General or Number format for a range of cells removes the Dollar Sign ($). Also, use the Format Cells window to change the number in other currency formats.

Method 2 – Inserting Custom Number Format in Format Cells Window

  • Type the below number format under Type in Format Cells > Custom.
_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)

Custom Format to Align Currency Symbol in Excel

  • The consequences of customizing the number format results in aligning the currency symbol.

Method 3 – Selecting Preferable Alignment for Aligning Currency Symbol

  • After displaying the numbers in Currency format, align the number Left, Right, or Center using the Alignment section of the Home

Alignment to Align Currency Symbol in Excel

  • All the alignment options result in the following depiction. Select the Left alignment to align the currency symbol.

Download Excel Workbook

Download the attached dataset to practice.

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF