Excel 2010 Business Math 26: Percent Conversions: By Hand and In Excel

[richardkinzer]

Mike are you using a stylist of some sort (Wacom?) on your PwrPt or your mouse, to use the pen tool? I like the idea of turning the screen into a whiteboard.

I'm learning to teach as well as better Excel from you. That's a little more I'll have to put on my account that I owe you.

[ExcelIsFun]

@richardkinzer , the way the "account that I owe you" works is that it is not really an account; because at the moment that you help someone else, that is the payback. The act of helping makes the world a better place and that is the reward! Anytime you teach - you make the world a better place!

Yes, you can just turn on PowerPoint in Slide Show Mode, right-click and point to pointer: then draw. I also have a "Bamboo" stylist ("Bamboo" is the name and it is quite old...).

[brian4ca]

Thanks.

[brian4ca]

When I highlight my decimals & use CTRL+SHIFT+% then it changes the cells to a percentage format. Can I make this default to have 2 decimals though? If my cell is .025 then it'll change it to 3%. Instead, I need 2.50%. It'd just be nice to set that default somehow in Excel if possible.

[ExcelIsFun]

@brian4ca , I totally agree!! I never use that keyboard because it shows zero decimals. I wish there is a way to change that default. I do not know of a way. The only way I know is to record a Macro and then assign it to a button on the QAT. But I just use the Number Format drop-down in the Number group in the Home Ribbon tab and point to the Percent with Two Decimals.