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?

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)