Export currency to numeric field in Excel?

A

angbob

I have a query with this statement in some SQL:
Format([T1].[V]*[T2].[V2], "Currency") AS [Value].

When I export the query to Excel, the Value field is exported to Text, not
to a numeric Number type.
One consequence is that adding a SUM to the Excel column produces 0.

Is there a way to get Access to export to a numeric Number?
 
J

Jeff Boyce

One approach might be to use the CCur() function, but leave off the
"Currency" formatting. Perhaps that's adding non-numeric characters that
Excel is then interpreting to be text...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Export price field in txt file without $ currency symbol 9
Export numeric field to text file with 5 decimal places 2
Zero fill numeric field 1
Maintaining Datatypes When Exporting to Excel 3
Linking table gets numeric field overflow 2
How do I export a query without a currency symbol to a comma deli 2
Export undefined queries to excel file 2

Top