Macro steps to reformat text into numeric on large data set

[Iowa Gal]

I found this old e-mail on this list and have a question on how to
write a macro that will do this:

"Your problem is that the spreadsheet was initially formatted as
text. You will
need to reformat it as number. Excel still views the cell as text.
Press the
F2 key (edit) in the cell with the text format and press the RETURN
key. This
forces EXCEL to recalculate and display the result as numeric. You
will have
to do this for all the cells. I hope this will help."

Sometimes I have a huge column of data to convert and it is impossible
to do <F2><Enter> for all those rows!

Unfortunately, I am rather a basic macro user - I only know how to
record keystrokes. I have gotten and incorporated some pretty useful
Visual Basic code for macros before, though. Any ideas on how to make
it go to the next row and repeat until it reaches the end of the data,
then return to the top or stop or something as a finale?

Thanks for any suggestions. ~ J. Koskey