vba 将列单元格“保存为文本的数字”转换为数字格式的宏
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18835677/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-08 16:37:42 来源:igfitidea点击:
Macro to Convert Column cells "Number saved as Text" to Number Format
提问by xyz
I am trying but to working
我正在努力但要工作
Thanks
谢谢
Sub Enter_Values3()
Dim dbl As Double
dbl = ThisWorkbook.Worksheets(2).Columns("A:A").Select
End Sub
回答by xyz
Marty McVry 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
Thanks
谢谢
回答by Ben C Wang
Have you tried using NumberFormat or CSNG?
您是否尝试过使用 NumberFormat 或 CSNG？
