I have a ComboBox list in a UserForm containing the numbers:

0.050
0.100
0.150
1.000
1.500
2.000

When I switch the WinXP Region Language to European (i'm in the US), I
have successfully declared the formatting to keep the 3 decimals and
replace the decimals with comma's so the list looks like this:

0,050
0,100
0,150
1,000
1,500
2,000

However, when I select a value from the list, it does not store in the
Excel Spreadsheet Cell as a number, but as a string of text. So, for
example, "2,000" would read "2000" in European Language formatting.

Does anybody know of a way to retain the numeric formatting and let it
carry from the ComboBox list in my UserForm to the ActiveCell?

Thanks!!!!