MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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

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

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

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