Number stored as text error, convert to number script

I am trying to write a script to fix the "number stored as text" error, but when I record a macro, it does not capture the steps. Has anyone experienced this, or have thoughts on code that will accomplish it?

Specifically, I mean when the green triangle indicator shows up, and gives the yellow triangle button with a menu of options, one of them being Convert to Number. The cell does not actually change to a number format, it stays general, but the error goes away, and the numbers can now be used with formulas.

Found a solution, in case anyone comes across this in the future.

When the cells you need to apply this to are selected, the below code worked for me.

Please Login or Register  to view this content.

Thank you!