By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Exporting Euros To Excel

P: n/a
I have a report which is sometimes exported into Excel using the following
code:
DoCmd.RunCommand acCmdOutputToExcel

This works fine if the default "Currency" format is used in the text boxes,
in this case it is UK pounds sterling.

If I change the format to "Euros" or format the text box for US Dollars
these columns are then exported as text. The correct currency symbol is
displayed but any calculated cells remain at 0.
Although I can manually select the column and convert the cells back to
numbers this is meant to be a semi-automated process.

Any suggestions would be appreciated.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.