How do I export an Access query to Excel with currency formatting?

I have exhausted my knowledge. I need my exported to Excel query to format the ATP field to currency. Simple query dividing Full_Service_Count (Data Type: Number) into Net_Sales (Data Type: Currency) to get my ATP field. I applied a Format to it which works in Access but once it hits Excel it displays it as $xx.xx but it is in the General format.

SELECT dds_Daily_Sales_Tb.Store_Number, dds_Daily_Sales_Tb.Operations_Day, dds_Daily_Sales_Tb.Full_Service_Count, dds_Daily_Sales_Tb.Net_Sales, Format([Net_Sales]/[Full_Service_Count],'Currency') AS ATP
FROM dds_Daily_Sales_Tb
GROUP BY dds_Daily_Sales_Tb.Store_Number, dds_Daily_Sales_Tb.Operations_Day, dds_Daily_Sales_Tb.Full_Service_Count, dds_Daily_Sales_Tb.Net_Sales
HAVING (((dds_Daily_Sales_Tb.Operations_Day)=Date()-1));

Select allOpen in new window

I tried an External Data->Excel export data with formatting and layout and I tried a basic Module exporting to Excel. Neither exports the field in currency

Function ExportQBTest()

DoCmd.TransferSpreadsheet acExport, 10, "C - TEST", "C:\Users\DDS Server\Dropbox (Broadbase)\Broadbase Team Folder\Quickbooks\DDS Test Files\Test.xlsx", True, "DDSTest"

End Function

Select allOpen in new window