why is the currency shows is always left aligned

The currency symbol when included in excel is always left aligned, and if my number is right aligned, there is too far a gap between symbol & the number which does not look pretty. How to get this changed?

1 Answer(s)


I just tried this. Type in some number in your cell. Then press Ctrl+Shift+4.

This should make it currency sumbol. By default this will be right aligned. Is this working?