I am running a sql query in Excel against an Access database so I that can perform analysis on the results.
But, 1st time i run it I realize the data is all coming back as text not numbers. Turns out the programmer found it easiest to write in access this way.
Once i extract the data, how can I easily convert it to numeric?
I know that if I select the alpha data carefully, an info box will appears that allows me to select "Convert to numbers".
But I need to convert automatically-maybe with a macro. So careful selection is out. Data will always be different shapes and sizes.
Is there a command in Excell that will apply this powerful conversion function at will to a range of numbers? I can only find it when I select a range that both starts and ends with an alpha that Excel thinks might be a number. Off by one cell and the info box never pops up.
I am going crazy!