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

Export BPMN Visio Chart to Excel 0
Autonumber field in Excel that behaves the same as Access 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Export to Excel - calculated field type conversion issue 0
Zero fill numeric field 1
Adding Cost Field to Appointment 0
Export price field in txt file without $ currency symbol 9

Top