excel vba‎ > ‎

VBA - Setting Format Cells

posted May 18, 2011, 12:56 AM by Roberto Felicini
set to Text
    Columns("A:G").NumberFormat = "@"
set to number with no decimal
    Columns("A:G").NumberFormat = "0"
set to date
    Columns("C:C").NumberFormat = "dd/mm/yyyy"
 
Comments