컴퓨터관련

엑셀 vba NumberFormat...펌

맘편한넘 2010. 12. 10. 22:04

 .Range("A1").NumberFormat = "0.0"
          .Range("A2").NumberFormat = "$#,##0;[Red]$#,##0"
          .Range("A3").NumberFormat = "m/d/yy"
          .Range("A4").NumberFormat = "m/d/yy h:mm"
          .Range("A5").NumberFormat = "0%"
          .Range("A5").NumberFormat = "General"