Can I create a toolbar or button to apply a number format?

[CHBC1]

I want to create a toolbar or a button that I can press to apply a custom number format (it's basically just putting the numbers into millions). Does this require VBA? I have basic VBA skills, so I would be willing to go that route, however I normally try to avoid putting VBA in spreadsheets I use at work.

I understand this is probably a newbie question, but I appreciate the help!

 

[RickXL]

Hi,

I can do it with some VBA. You need to paste this code into a standard code Module.

Sub MillionFormat()
    Selection.NumberFormat = "#.##,,"" M"";"
End Sub

Now add a button to the Quick Access Toolbar to run the macro.

After that, to format cells just select them and hit the button.

You could put the macro into a Personal workbook and then it would not need to be added to every workbook you used.