excel - 将列单元格 "Number saved as Text"转换为数字格式的宏

Question

我尝试了以下方法，但不起作用:

Sub Enter_Values3()
Dim dbl As Double
dbl = ThisWorkbook.Worksheets(2).Columns("A:A").Select
End Sub

Answer 1

马蒂·麦克弗里 Link worked

Sub macro()
Range("A:A").Select 'specify the range which suits your purpose
Sheets(2).Select
With Selection
    Selection.NumberFormat = "0"
    .Value = .Value
End With
End Sub

谢谢