VBA to convert text to number

[ItalianPlatinum]

Hello - I have an existing range that starts on E11:F11 then can do down forever. but the code i currently run that i cannot modify sets that values in those columns to text (green arrow top left). Is there a quick VBA code to auto convert from E11:F11 down to number format? i have other cells that reference that and whenever it text it doesnt work. Thanks in advance.

 

[cortexnotion]

Try this...

With Sheets("xxx")
.Range("E11:E" & .Range("E" & Rows.Count).End(xlUp).Row).TextToColumns Destination:=Range("E11"), DataType:=xlDelimited, Space:=True
.Range("F11:F" & .Range("F" & Rows.Count).End(xlUp).Row).TextToColumns Destination:=Range("F11"), DataType:=xlDelimited, Space:=True
End With