Export currency to numeric field in Excel?

  • Thread starter Thread starter angbob
  • Start date Start date
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?
 
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
 
Back
Top