Range("A1:A10").NumberFormatLocal = "@" '文本格式Range("B1:B10").NumberFormatLocal = "yyyy-mm-dd" '日期格式Range("C1:C10").NumberFormatLocal = "[DBNum2][$-804]G/通用格式元整" '人民币大写Range("D1:D10").NumberFormatLocal = "0.00%" '设置D1单元格为百分比格式
其它格式定义详见:/jyh_jack/article/details/47953525