Formatting Cells Number General Range("A1").NumberFormat = "General" Number Range("A1").NumberFormat = "0.00" Currency Range("A1").NumberFormat = "$#,#0.00" Accounting Range("A1").NumberFormat = "_($* #,#0.00_) _($* (#,#0.00) _($* Date Range("A1").NumberFormat = Time Range("A1").NumberFormat = "h:mm:ss Percentage Range("A1").NumberFormat = "0.00%" Fraction Range("A1").NumberFormat = "# ?/?" Scientific Range("A1").NumberFormat = "0.00E+00" Text Range("A1").NumberFormat = Special Range("A1").NumberFormat = "00000" Custom Range("A1").NumberFormat = "$#,#0.00_) ($#,#0.00)" Formatting Cells Alignment Text Alignment Horizontal
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |