I have a query with some fields like this: ODDraw: IIf([Daily Draw/Repayment OD]>0,[Daily Draw/Repayment OD],"")
When I export to excel, the column is text not currency. I have also tried to apply a format such as #,##0.00;[Red](#,##0.00) thinking that the export would be as a currency and not text but this did not work either.
How can I export as currency?
thank you in advance.