Hi Colin.



That worked, thank you.

But this leads me to one more question, if I may.

What I originally tried to do was select the entire column (by clicking the top section marked H) and then try to convert to numbers. I wasn't able to do that. If I had, oh, several hundred records--or even a thousand--it would take a long time to drag the mouse down the entire column.

Is dragging down the column, as per your instructions, the only way to do this?

I'm assuming you cannot select the entire column the way I want to because of the header row? Is that correct? Why, then, would I not be able to highlight the entire column by hiding the header row?

Just curious about that. Thank you once again. Jd

Hi Jd,

It looks like the way the Excel developers designed it is that, when you select the cells in that way, the first (visible) cell must have an error in it. The first, visible cell of the selection in this situation is the activecell.

So, if you select the whole of column H and if H1 has an error then it should be okay because H1 would be the activecell.

If H1 doesn't have an error value but H2 does, then hiding the whole of row 1 and then selecting the whole of column H should also do the trick because H2 would be the activecell.

Hope that helps...
Colin

If you press Ctrl-End, that will take you to the last active cell in the worksheet. Pressing the Home key will then take you to column A. Of course, you can navigate to the left by scrolling. You can also scroll up from the bottom if you don't want to include the very last row.

To select from there to the top of the column, hold down the Shift key and press Ctrl-Home and scroll to the desired column. Keeping the Shift key depressed, you can also scroll down from the top of the column to another row if you prefer - and you can span more than one column if desired.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]