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 ?|
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:
Click on number format field and select More Number Formats:
Then select Custom in category section:
Enter custom number format into Type field, for example #,##0.00 $:
The result should look like:
|How to add side by side rows in excel pivot table ?|
|Free email accounts with large or unlimited storage capacity|
|Does LTE mean 4G ? Difference between LTE and 4G|
|Check if value exists in column more than once or twice - Excel|
|How to calculate inverse currency exchange rate ?|
|What is definition of ROA, ROI, ROE, ROS, EBITDA in finance ?|
|What is good PPI of smartphone display ? How to calculate it ?|