Export query with currency removed into comma delimited file
I know that it is possible to export a query into a comma delimited file from Access, however, my problem is that I have currencies in my table. I selected the field that is a currency in the query and changed it to a general number. I then exported it into a csv file, but the currency symbols are still showing. I also tried exporting the query results using a macro, but then I have these long dashes and heading in the file. There were also | seperating the fields in the file. How do I fix this?
I just want to be able to export the query result without the currency symbol into a comma delimited file.
Thanks for all your help