change of currency in excel

M

Maggie

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.
 
B

Bernard Liengme

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
 
N

nfetterly

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

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



I am having the same problem - I recently reformatted HD & reinstalle
all software on my laptop & when I click on the currency symbol t
format a cell in Excel 2003 the Euro symbol comes up - my computer i
set to the USA in the regional settings. This did not happen previousl
before I reformatted.

The only "odd" thing I have is I am running Excel 2003 - all my othe
office programs are 2007 (Excel 2007 is not installed this time). I ha
a huge issue with Excel 2007 not "playing nice" with my grouped shapes
and the new menu isn't as good as a customized one in 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top