The Newton/Galileo posts here will continue with their Italian theme for some time yet, but since I am now back in Australia it’s time to give Excel a look in again.
I recently (well a couple of months ago) had a query about using the Eval User Defined Function (UDF) when the decimal separator was set to a comma, rather than a decimal point. In response to that I added an option to the code for Eval and Evala that would replace all occurrences of “,” with “.” and “;” with “,”. This allows the Excel Evaluate command to operate correctly, regardless of how the values are entered.
The revised spreadsheets using these functions may be downloaded from:
Note that the modification has as yet only been made in the Eval and EvalA functions, and not the integration functions.
After modifying the code I discovered that there is an Excel option that allows the original functions to work, without substituting commas for decimal points. In Excel 2010, under File-Options-Advanced, deselect “Use System Separators” and enter a “,” for Decimal Separator, and a space for Thousands Separator.
The spreadsheet will now display decimal numbers with a comma separator, and will only accept a comma as the separator for new numbers, but the Eval functions will work correctly.
However – this (strangely) only seems to work if the region language is set to English. If the region is set to French (or presumably any other region that uses the comma separator) the original Eval functions no longer work. I have only given this limited testing (since I normally use the decimal point), so if anyone else has any comment on how the regional separator options work in Excel, please leave a comment below.