Output

[Guest]

Good afternoon Everybody,

I use a macro to export a query to an Excel Spreadsheet and that works fine,
the data's present on spreadsheet but I must always select all of the data
and right click and ask computer to "convert to number" in order for a chart
to see the data. Does anybody know how to automatically do this in export
process or a way to do this automatically from Excel? Thanks

 

[Sergey Poberezovskiy]

One way to do this would be defining a new column (in
Excel) with a formula similar to the following:
=value(A1)
assuming that A is your number column and base your chart
on newly created column.

HTH