Thousand separator

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fran - 28 Jun 2005 02:51 GMT

Hi,

I installed Excel having my keyboard set to Spanish and now the default
currency and number formatting uses dot as thousands separator and
comma(,) as decimal. I have tried to change it, because I need to use
dot(.) as decimal and comma(,) as thousands separator.

I get 1.000,00 and would like to get 1,000.00.

Please help me.

Thanks.

Reply to this Message

J Laroche - 28 Jun 2005 03:25 GMT

fran wrote on 2005/06/27 21:51:

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thanks.

You have to use OS X's System Preferences, under the Apple menu. What you
want is in the International pane, under the Formats tab.

JL
Mac OS X 10.3.9, Office v.X 10.1.6

Reply to this Message

fran - 29 Jun 2005 15:16 GMT

Thank you,

I tried that but when I go back to Excel, nothing happens, I do not
know if it is necessary to reinstall Excel after changing the
preferences in order to get the format I need, do yo know? I am using
Mac OS 10.4 and Excel 2004

Regards,

FV

> fran wrote on 2005/06/27 21:51:
>
[quoted text clipped - 16 lines]
> JL
> Mac OS X 10.3.9, Office v.X 10.1.6

Reply to this Message

Bernard Rey - 29 Jun 2005 21:00 GMT

fran:

> I tried that but when I go back to Excel, nothing happens, I do not
> know if it is necessary to reinstall Excel after changing the
> preferences in order to get the format I need, do yo know? I am using
> Mac OS 10.4 and Excel 2004

There's no need to reinstall Excel or even to restart or log out. But
re-launching Excel is required (and is/should be enough). Did you re-launch
Excel once the settings in "International" > "Formats" have been modified?

---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

Signature

Bernard Rey - Toulouse / France
MVP - office:macintosh http://faq.office.macintosh.free.fr

>> fran wrote on 2005/06/27 21:51:
>>
[quoted text clipped - 10 lines]
>> JL
>> Mac OS X 10.3.9, Office v.X 10.1.6

Reply to this Message

Mac Forum / Applications / Excel / June 2005

Thousand separator