conversion of validity list

H

hasan

Hi all,

I'm using Excel 2003 with country settings German(Austria)

I hade defined a validity check of type list with source:
1; 1,5; 2

When I change the country setting to English the source
will turn to: 1, 1,5,2 (where 1, 1.5, 2 would be right).

1,5 is no more numeric which causes a problem.

Does someone know a solution to this bug (without using
cell references as source while staying with list as
validity type)?

Thanks
Hasan
 
Top