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"