7,763
社区成员
发帖
与我相关
我的任务
分享
Private Sub 文本转数字()
With ActiveSheet.UsedRange
.NumberFormatLocal = "G/通用格式"
.Value = .Value
End With
End Sub
dim x as long
dim y as long
for x=1 to 10
for y=1 to 2
cells(x,y).formular1c1=cells(x,y)
next y
next x