[AccessD] A2K, Export to Excel

Hi Francisco

Try setting the format property of the field in the query to "Number"
and two decimals. If this doesn't help, you may need to fall back to
use Format() in an expression.

/gustav


> A friend has a query, and is exporting the results to an excel file,
> for some reason the numeric (dollar) values are converted to string in
> excel (the single ' quote problem) it's easy enough to convert excel
> to see it as a numeric but why?

> thanks,
> -- 
> -Francisco