Thread: VBA Code Help - Convert to Number

After importing my report to Excel my numbers are listed in text format with the green arrow in the upper corner (see attached worksheet). For my situation, the problem can easily be fixed by highlighting all of the fields and selecting "Convert to Number" from the exclamation point drop down.

Is there a way using VBA Code to replicate this process? I would like all of my values to retain their format (percentage, dollar, etc). but no longer have the green notices in the upper corner.

Any help would be greatly appreciated. Thanks!

Try:

Range("B3:I6").Value = Range("B3:I6").Value

Regards