Data validation issue

[fastbiker]

I have a spreadsheet I use that has data validation for cells with currency amounts. I use the semicolon as a list separator and have it setup in control panel that way.

The spreadsheet is a template, when I open it, it functions fine the dropdown boxes work. However when I go to save it, and open it again it somehow has replaced all the commas with semicolons and the dropdown boxes do not work correctly.

This is a very recent occurrence, it used to work fine. Any ideas out there?

Running on windows server 2000 and excel 2007, also does the same thing on windows xp machine I have. Makes no difference if I save it as macro enabled, template, etc

Here it is

[martindwilson]

repost in 2007 forum