Is there any way that I could set the default display format for "currency"
data type to a pure figure (without the "$" symbol in the front)?

I am exporting data from access to excel. Those "currency" data type figures
are displayed with a "$" symbol in excel. Even if I change the display
format, there will be "$" again next time when I export. How can I resolve
this?