ComboBox Decimal Errors
 

Hi,

I am using the English version of Excel on Windows XP, and the project
I am working on is used in the United States and Europe.

I have a properly-working English version, but when I change my
Regional and Language settings from the Control Panel in Windows from
English (United States) to German (German) or any other European
Language, I have a problem with the decimal formatting in ComboBoxes.

I format the selected value in the ComboBoxes with this code:

comboBox1.Text = FormatNumber((Worksheets("Worksheet1").Cells(13,
5).Value), 3)


In German regional language settings, if I select anything greater than
0,999 from the list, it will eliminate the decimal seperator. For
example:


Select 0,999 from the list, it will show 0,999 in the comboBox after I
leave focus...

I select 1,000 from the list, and it will show 1000 after I leave
focus...


This problem also stores "1000" in the worksheet as well!

Best Regards,
Tyler