new currency and set it default

[Soe]

how can i put new symbol of currency and set it to default?

 

[Norman Harker]

Hi Soe!

You can change it with:

Start > Control Panel > Regional & Language Options
Customize
Currency Tab
Change the currency.
Apply
OK

(These are for Windows XP but you should be able to "follow your nose"
after double clicking on Regional)

Usually currencies available are limited to a narrow range based on
your country setting but there is nothing to stop you inserting a
different one.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Soe]

Hi,
Thanx.
I have tried that, however, whenever I reopen excel application, the
error "No more custom format can be added" prompted.
Moreover, "$" sign disappear from Selection list. What I am expecting is
new currency say "S$" first, then followed by normal "$" sign.
Any suggestion?

 

[Norman Harker]

Hi Soe!

I'm not getting any problems with A$.

Regarding the error message, Here's an extract from a March 2003 post
by Dave Peterson

"You could try this:

John Walkenbach keeps David Hager's EEE tips at his site.
http://j-walk.com/ss/excel/eee/eee015.txt
Look for: SPECIAL VBA PROJECT: Custom Number Formats

And
XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213904

(about 4000 isn't enough for you and many of my co-workers!)"


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Peterson]

I've seen a couple of posts that say that OpenOffice can open files with too
many formats--ones that some versions of excel have trouble with.

I'm not sure if this is a problem for you (yet!), but you may want to get a copy
of OpenOffice so you can clean up some of those custom formats (if/when you have
trouble with xl).

(http://www.openoffice.org, a 60-65 meg download or a CD)