Convert to Number

[[email protected]]

It's never easy, is it?

In the attached sample, I'm just trying to get a total of columns E, F and G, and place those totals in row 5.

The problem is that somehow the numbers in column G were stored as text, so the SUM formula is coming up "0". How would I format these cells, in a macro, (columns E, F and G, just in case the data in the other two columns were stored as text), as a number so that I can total them.

I've tried selecting the column, selecting format cells and choosing number, but that doesn't work. I can manually select the cells, click the little exclamation point, and then tell it to convert to number. This works, but when I tried to record it to add it to the macro, it didn't record anything but the selection of the cells.

Thanks for any help you can offer.

Hutch