I have a link in an Excel spreadsheet to get external data from an MS Access database, containing a query. This query produces some fields containing numerical values.
But when the data is downloaded into Excel, it is treated as text with zero value. If I calculate another cell using these values, the value of the calculated cell is always zero.
My workaround has been to copy a "1" and paste special - multiply on all of these columns. From that point onwards, they start behaving as numbers and the calculated cells become alive.
The workaround is tedious and I have to do it again and again. How can I do it more elegantly?