By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 185 - Formatting Routines


Most of the formatting you do in VBA is via the Macro recorder.

Formatting is some of the messiest code you will have.

Record a macro and set the formatting to columns H and I to #,
  • 0.

    You'll get the following

       Columns("H:I").NumberFormat = "#,
  • 0"


    The # is a number that will hide if a 0.

    So for example

    Another way is via the Format command.


    ASP

    Doesn't support Format


    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit