Forum Discussion
Szymeqpl_
Oct 11, 2023Copper Contributor
Converting text to numbers.
Good morning, While getting data to excel, numbers were stored as text on multiple worksheets. Is there a way to convert text to numbers in all worksheets?
- Oct 11, 2023
A macro:
Sub ConvertTextToNumbers() Dim wsh As Worksheet Application.ScreenUpdating = False For Each wsh In Worksheets With wsh.UsedRange .NumberFormat = "General" .Value = .Value End With Next wsh Application.ScreenUpdating = True End Sub
HansVogelaar
Oct 11, 2023MVP
A macro:
Sub ConvertTextToNumbers()
Dim wsh As Worksheet
Application.ScreenUpdating = False
For Each wsh In Worksheets
With wsh.UsedRange
.NumberFormat = "General"
.Value = .Value
End With
Next wsh
Application.ScreenUpdating = True
End Sub