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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default display format for "currency" data type
Maybe....
I think it depends on how you're importing the data into excel. If you're bringing the data into an existing workbook, you _might_ be able to play with the Currency style. Format|Styles|select Currency and change what you want. The bad news is that styles live in workbooks. So if you have a workbook that has a different Currency style, you'll have to change it there, too. If this does work and you want every new workbook to have this customized Currency style, you can Create a new workbook Change the Currency style (and anything else you want) Save the file as a Template file (*.xlt) Use the name Book.xlt and save it in your XLStart folder. Whenever you click on the new icon on the standard toolbar, that template workbook will be used as the basis for the new workbook. == Remember, you'll have to do some testing to see if this works for your process. Cynthia wrote: 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? -- Dave Peterson |
Reply |
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 |