PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes conversion of validity list

Reply

conversion of validity list

 
Thread Tools Rate Thread
Old 05-11-2004, 09:20 AM   #1
hasan
Guest
 
Posts: n/a
Default conversion of validity list


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
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off