Forum Discussion
Can't get the Currency Symbol for a cell
Hello Everyone, I can't see the Eur (or any currency symbol) for this cell. this is a merged-and-centred cell. I want to show $ 4540 Annual Savings!! with the help of formula. So, what fo...
Currency and Accounting formats only apply to cells that contain a number.
Your cell contains a text value, so Currency or Accounting format will be ignored.
You can edit the cell value and manually type $ in front of it, or whichever currency symbol you want. The Euro symbol is Alt+0128 using the Numeric keypad (turn on Num Lock first).
- Thank you so much sir..
