EXCEL Locales


A common problem with non-English locales is that the locale settings for the decimal symbol as set on Control Panel …

 

 

 

 

 

 

 

 

 

 

 

 

… can be overridden in Excel options:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

It must be the same in both – either both a period, or both a comma.  The Ruby push/pull system expects one or the other. The standard setting for non-English locales would be comma in Control Panel, and Use System Separators ON in Excel:

 

 

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.