Remove "US" from "US$"

Hello

Alas we can't.

It would be useful to:

*go to "Provide Numbers Feedback" in the "Numbers" menu*, and ask Apple to obey to ISO 4217 which defines the way to display currencies.
Then, cross your fingers, and wait at least for iWork'09 😉

Yvan KOENIG (from FRANCE vendredi 15 février 2008 10:17:34)

I'm in New Zealand ~ We use dollars.
I have the spelling set to British English as usual.
Seriously though: Send feedback.

You can use whatever symbol you like through the system Character Palette (Insert into cell before the number)

Best

Message was edited by: Ashka

Ashka wrote:
You can use whatever symbol you like through the system Character Palette (Insert into cell before the number)

Of course we may do that but the value will no longer be a number.

The currency format was created to take care of that.

Alas, Apple made surprising things.

At this time, in this area, the more funny I met it for Turkish currency.

The operating system uses YTL
Numbers says TRY but with this symbol it see a string
and, at last, to get a working currency they must use TL.

Yvan KOENIG (from FRANCE vendredi 15 février 2008 19:54:1)

Hi Yvan
If the format is set to automatic the £ I inserted from the character palette makes no difference to the number format.

OK Sorry:: Checked everything again
Numbers was changing the automatic setting to Sterling automatically.

It does make me wonder if one could insert $ and have numbers change to using just $ automatically rather than NZ$. US$ etc.

Message was edited by: Ashka

Wahooh

What a surprise. I'm so acustomed to the AppleWorks behaviour with the currency values that I always thought that Numbers was working the same.
It works also with the european € (after the digits).
Using the palette or typing from the keyboard, it doesn't matter.
It insert automatically a space between the digits and the symbol.

I hoped that it may offer a soluce for documents requiring two currencies but, for € and $ it doesn't.
Here the decimal separator is comma.
If I enter $ 12,34 it reformat it to 1 234 $
If I enter $ 12.34 it's a string.

But, I'm glad, I learnt something 😉

Yvan KOENIG (from FRANCE vendredi 15 février 2008 20:47:44)

Hi Ian,
On my system, $ default, setting the format to automatic, inserting a £ though the Character palette then typing the number with decimal places changes the format to sterling.

I was hoping that if you, with default £, setting format to automatic, inserted a $ then typed the number required including decimal places, that the format would change to using just $ rather than US$ etc.
Best.