Applying a Number Format

February 08, 2013

0 comments

Applying Number Format   Excel Shortcuts for Mac   Formatting Cells   Formatting number cells   How Excel Skin Works   Mac Excel Shortcuts  



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.

 

Applying the number format with two decimal places, thousands separator, and minus sign (-) for negative values.

This shortcut provides a fast and easy way to manipulate your data with a predetermined format.  This predetermined format is one of many that are built into Excel but few users know about it.  In the following steps you will learn how to add two decimal places, a thousands separator, and a minus sign for negative values to a specific cells, or range of cells, without opening up the Format Cells dialog box. 

Step 1: Select the cells we want to manipulate.

 

Step 2: This shortcut is found on the “1” 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.  The “Control” and “Shift” keys have white text as well.  Execute the shortcut by pressing the following keys:

 ⌃⇧!

 

Our data has now been manipulated to have two decimal places, a thousands separator, and a minus sign if a negative value is present. 

 

This shortcut shows one of the many ways to increase efficiency in Excel for Mac.  By simply pressing three keys we avoid opening the Format Cells dialog box and the inevitable mouse movement needed to format the cells. Now you can easily reformat your cells to this predetermined format of two decimal places, a thousands separator, and a minus sign if necessary.  Enjoy all the free time you just saved!

 



Leave a comment

Comments will be approved before showing up.