Excel Text to Number Formatting
Posted on 2012-03-27
I am running into problems with numeric data when I import it into MS Access, and export back to Excel. It converts the numeric data to text. I found solutions for this on the internet but the only one that seems to work is to go to the Error Checking button and manually tab through every field in the spreadsheet until all are converted. There has to be a better way. Using the standard method of formatting does not work for this. I have to perform calculations on this data and the spreadsheet is going to get very large and this method will be time consuming and tedious. Can someone assist?