Excel tip: Align currency symbols to the left
Date: 10 september 2001To have the currency symbol appear on the left of the cell rather than just to the left of the number, include for example, $* or �* followed by a space at the beginning of the number format.
The example on the left uses the number format: "�* #,##0;�* -#,##0" (without the quotes).
The * means repeat the next character, which in this case is a space, enough times to fill the width of the column.
| � 1250,0 | � 1250,0 |
| � -1250,0 | � -1250,0 |
« back
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.