ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   change of currency in excel (https://www.excelbanter.com/excel-discussion-misc-queries/237983-change-currency-excel.html)

Maggie

change of currency in excel
 
Excel 2003 - has automatically changed its currency format in the main
program from Australian Dollars to Euro. I have the Euro symbol present and
all cells format in Euro. How can I change the program back to Aust.Dollars
as a standard setting in the program? I do not want to have to change the
format every time I open a new worksheet.

Bernard Liengme[_3_]

change of currency in excel
 
Three things to try:
1) Open the Windows Control Panel, locate Regional Setting and see what you
have there for currency
2) In Excel, on the Home tab, locate the Styles group, click Cell Styles.
Locate Currency and right click the icon; use Modify and see what symbol is
being used for currency
3) Have you somehow got a Book.xlxs in the XLSTART menu that is being used
as the default template and it has euro for money?

If none of these solve it, please come back. There has to be a solution.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Maggie" wrote in message
...
Excel 2003 - has automatically changed its currency format in the main
program from Australian Dollars to Euro. I have the Euro symbol present
and
all cells format in Euro. How can I change the program back to
Aust.Dollars
as a standard setting in the program? I do not want to have to change the
format every time I open a new worksheet.





All times are GMT +1. The time now is 11:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com