2,462
社区成员
发帖
与我相关
我的任务
分享
Sub 格式化单元格数据()
Cells.NumberFormat = "000000"
End Sub
Sub Test()
Dim i As Single
Application.ScreenUpdating = False
Application.EnableEvents = False
i = Timer ''记录开始时间
''设置a1单元格格式
Range("a1").NumberFormatLocal = "000000"
Range("a1").Copy
''开始粘贴格式
Range("a2:a65536").PasteSpecial Paste:=xlPasteFormats ', Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Range("a1").Activate
Debug.Print Timer - i
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub