| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default display format for "currency" data type
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
| Can't set default type to "Clustered Column" | Charts and Charting in Excel | |||
| How to set the default "summarized by" of a data field to "Sum"? | Excel Discussion (Misc queries) | |||
| Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
| In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
Threaded Mode
