Applying the currency format with two decimal places

March 02, 2013


applying currency format   Excel on Mac   Excel Shortcuts for Mac   Format Cells   Mac Excel Shortcuts   mac shortcuts for excel  

We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.


Currency Format with Two Decimal Places

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.  

Leave a comment

Comments will be approved before showing up.