Excel displays #Value! when regional setting chang

Question

I just came cross an issue where Excel would display #Value! when regional setting was set to non-English format. (Control Panel-> Region and Language-> Pick Non-English Format from the list)

It's fine if user selects English. All the UDF results will come through and get displayed correctly in the cells. It just wouldn't work for non-English ones.

I have had a look at some of possible solutions online, like these ones: http://support.microsoft.com/kb/320369
http://msdn.microsoft.com/en-us/library/aa168494(v=office.11).aspx

So I did what's suggested, but still no luck. Excel always gives me #Value!. Has anyone here had similar issue like this before? Any better solutions? Thanks.

Answer 1

change commas , in your formulas to semicolons ; - or whatever List separator is specified in your Region and Language > Additional settings...