Euros and USD formatting errors

[Evan M]

Hello, I have an invoices form that has the option to choose from using
Euros or US dollars when inputting prices. Basically, I need to have the
prices in the textboxes show up in either Euros or USD, depending on the
selection in that currency type cbobox. When the selection is made, I have
the formatting in each of the textboxes change to the specific currency
selected, and which works wonderfully, except for one small issue - the
format of the euros is incorrect. It formats the currency as "1,000.00",
whereas it should be "1.000,00". Does anyone know how I could change this?

Any help would be great! Thanks!
Evan M
evan AT radiologyonesource DOT com

 

[JohnFol]

Not true.
On the continent it's 1.000,00 but in the UK it's 1,000.00

This is the "Decimal Separator" and not a currency issue.

 

[Evan M]

Yes, however our office is on the continent, not the UK....

 

[JohnFol]

When I go into Regional Settings my "Standards and Formats" is set to
English (UK). The sample Currency shows £123,456,789.00


This is the experiment I tried

Dim x As Currency
x = 123456789 / 100
Debug.Print Format(x, "currency")

and I get
£1,234,567.89


I then set under Regional Settings my "Standards and Formats" to be German
(Austria)
The sample Currency shows
? 123.456.789,00

When I re-run my test I get
? 1.234.567,89

So I don't think this is a currency setting, more of a number format issue
with the machine's locale.

If I've missed anything (like the fact you might be using the format
differently) please feel free to correct me .. .

 

[JohnFol]

for ? please read "euro symbol"

When I go into Regional Settings my "Standards and Formats" is set to
English (UK). The sample Currency shows £123,456,789.00


This is the experiment I tried

Dim x As Currency
x = 123456789 / 100
Debug.Print Format(x, "currency")

and I get
£1,234,567.89


I then set under Regional Settings my "Standards and Formats" to be German
(Austria)
The sample Currency shows
? 123.456.789,00

When I re-run my test I get
? 1.234.567,89

So I don't think this is a currency setting, more of a number format issue
with the machine's locale.

If I've missed anything (like the fact you might be using the format
differently) please feel free to correct me .. .