Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

2.000,- or 2,000.-

Posted by Paul van der Weyde on August 29, 2001 8:08 AM

Hi. First of all, I'm an Excel novice so please forgive me this dumb questions. (my english isn't that great either)
I use an english version of Excel which displays currency numbers as follows: 0,000.00
Altough i think this is probably a proper notation for american currency, in Europe we use 0.000,00.
Is there a way to alter this setting, or should i go and buy a Dutch version?

Thanx in advance
Paul

Re: 2.000,- or 2,000.-

Posted by Mark w. on August 29, 2001 8:11 AM

If you're using Windows change your Regional Settings
control panel.

Superb email address : - ) (From an Englishman's point of view anyway)

Posted by Anon on August 29, 2001 8:31 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.