Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,104
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CHANGE CURRENCY TO ZAR lpplumbers Excel Worksheet Functions 1 January 16th 09 12:11 PM
how to change currency format into sentence in excel? Brian Excel Discussion (Misc queries) 4 May 3rd 08 02:31 PM
How do I change standard currency on excel toolbar? Mark Bunting Excel Discussion (Misc queries) 2 January 3rd 07 05:25 PM
Currency change RBeau Excel Discussion (Misc queries) 3 April 27th 06 08:45 PM
im trying to change the default currency for my excel from $ to M. tci Excel Discussion (Misc queries) 1 March 12th 05 08:35 PM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"