Data from Access query to Excel

[Robert]

To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?

Thanks

 

[Debra Dalgleish]

There are instructions here for converting text to numbers:

http://www.contextures.com/xlDataEntry03.html

You can select all the columns, and only the numbers will be affected.
After converting the data, you may have to reformat some numbers and dates.