VBA to format cells to Values

[kenadams378]

I have a column of data where some data are showing as values and some data is showing as a number with an error message attached to it asking me to convert to a number?

Is there a way to convert all the data to a number through VBA?

[romperstomper]

Usually you can just use Text to columns on it manually (assuming the cells aren't formatted as Text - if they are you should change that first), or in VBA:

With selection
.numberformat = "General"
.value2 = .value2
End With

for example.