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 186 - Selection.NumberFormat = "mmm-yy"


This statement can be recorded to format a date to be in mmm-yy format.

The mmm is the 3 character month code, ex. Jan, Feb, Mar, ...

and the yy is the 2 digit year.

The Selection is the currently selected cells on the ActiveSheet in the ActiveWorkbook


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