T
Tyler
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
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