Easy Excel VBA Number Formatting - Excel VBA Quickie 13

Quick tip for getting the code for Number Formatting in VBA/Macros correct for Excel.

This tip shows you how to avoid remembering the complex long number formats that Excel uses and it also shows you how to make it as easy as possible by automatically generating most of the required code.

In addition to the basic number formatting trick, I show you how to easily update and change range and worksheet references in VBA so you can more dynamically apply your number formatting using a macro in Excel.

Enjoy!

Excel Courses:

#msexcel #excelquickie #tutorial

[doreshel]

Hi
Great video, simple, clear and very helpful
Thanks

[jeffmartinez]

Great video. And thanks for reminding us that recording and reverse-engineering the code is always a good option. It's a technique that I use quite a bit when I'm doing something new, unfamiliar, or it's been a while since I used certain commands.

[piotrszymanski]

Hi again great video. I got a question about something different. I want to set timer in excel spreadsheet it will be multiple rows with my tasks and wants to set timer for each one to countdown time. Will it be possible?

[agusp]

I want to format custom like this " " * @ please help sir

[wayneedmondson]

You mean you have not memorized all the number format codes?? Shame on you :)) Great tips! Thanks!!