Apply Currency Format in Excel Spreadsheets

Currency format will add your regional currency symbol, put in comma separators for thousands, millions etc, and display two decimal places. It will also display red text for negative numbers.
To set Currency format, select the cells and press Control + Shift + $
As mentioned before, Screen Reader users can get format details for a cell by pressing the Screen Reader key + F.

Thanks to Excel Campus for the graphic in this week’s shortcut.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.