This shortcut is another quick and easy way to manipulate your data with a predetermined format. Two weeks ago we discussed how to apply two decimal places, a thousands separator, and a minus sign if necessary to a cell or range of cells. This week’s shortcut is along the same lines as it applies a predetermined currency format with two decimal places
Step 1: Select the cells we want to manipulate.
Step 2: This shortcut is found on the “4” key and is labeled “$#,###.00”. Looking at our Excel Skin we can see that the text for this shortcut is in white, so we take a look at our modifier keys. We can see the “Control” and “Shift” keys also have corresponding white text. Execute the shortcut by depressing the following keys:
Our data has now been manipulated to have a currency format with two decimal places. This number will show up in red with parenthesis if it is a negative value.
As our second predetermined format shortcut, the amount of time saved from not having to open the Format Cells dialog box and manually applying these formats is tremendous. Being able to make the number 15555 turn into $15,555.00 with the click of three buttons will greatly enhance your productivity and efficiency in Excel for Mac.
Comments will be approved before showing up.