I have imported some huge data files, and Excel is reading the numbers and
dates as text. I can click on the Formula Audit Toolbar, and it will scroll
through each cell - all 64,000 of them!, giving me the options.

Is there a way to just blanket the column and say, yes, convert XX to 20XX,
and in the next column, yes, convert text to number, etc.???