I'd like your help to repeat the below code to all file sheets to convert "Column B" from text to number. I have tried next for function but it gives me error every time I run it.
Screen shot from the file sample
Sub convert ()
[B:B].Select
With Selection
.NumberFormat = "General"
.Value = .Value
End With
End Sub
Screenshot:
No comments:
Post a Comment