Home > VBAUsefulCodes
Format Columns or Ranges with specified Number Format like General, Date etc..
Number Format
Format Columns or Ranges with specified Number Format like General, Date etc..
Thisworkbook.Sheets("SHEETNAME").Range("A:A").NumberFormat = "m/d/yyyy" ' Date Format
Thisworkbook.Sheets("SHEETNAME").Range("A:A").NumberFormat = "0" ' General
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts