[AccessD] A2K, Export to Excel

Gustav Brock gustav at cactus.dk
Tue Nov 9 05:02:45 CST 2004


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




More information about the AccessD mailing list