How to show Euro, Dollar or Pound sign on right in Excel ?

Is it possible to align Euro, Dollar or Pound currency symbol to the right side in Excel ?
02 Aug 2019 at 07:28 PM
0pnshow more
GillGill
Follow us on find us on facebook follow us on twitter
Hi,

To display the currency symbol on the right side, you have to create and apply custom number format. The creation of own number format is quite easy. You can also choose, if there should be a whitespace between value and currency.

Select the cells with currency values:

currency symbol right side excel

Click on number format field and select More Number Formats:

currency symbol right side excel

custom number format excel

Then select Custom in category section:

custom number format excel

Enter custom number format into Type field, for example #,##0.00 $:

dollar symbol right side format excel

The result should look like:

dollar symbol right side excel


04 Aug 2019 at 02:36 PM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
2021 AnswerTabsTermsContact us