Excel VBA format text as number issue

See more:

VBA

Excel-2016

I have data that I import to an Excel spreadsheet. Age is reported as "GENERAL" with the green indicator noting that the number is stored as a text. I would like to convert the entire column of ages to a NUMBER format. Should be easy!

Manual attempts to reformat as a NUMBER fails with the green indicator still appearing. The number still behaves as text. There is no apostrophe preceding the number.

Attempts at reformatting as CUSTOM ###0 also fails to remove the text formatting.

Using the Green indicator box and converting text to number does work, but I want to fix the entire column via VBA code, in order to perform operations on many rows of data.

This VBA code has no effect:

Range("H2:H" & Last_Row).Select
Selection.NumberFormat = "#,##0"

Any ideas how to do this? Does the report change the sheet to where the text is somehow sticky?

Thanks!
Sleeper

What I have tried:

Range("H2:H" & Last_Row).Select
        Selection.NumberFormat = "#,##0"