Quote:
Originally Posted by loofou
Maybe Excel has it's own regional settings somewhere, I need to check this.
[EDIT] Indeed Excel has it's own settings and for some reason those were set to really weird values. I don't know how I never noticed that! I set it to the correct values and most of the problems with the sheet are gone.
|
Yup. For anyone else that's looking to go Excel Options -> Advanced -> under Editing Options there's a checkbox for Use System Separators. You'd need to either check the box if it's using something odd or uncheck the box and set the two separators to . for decimal and , for thousand.
Quote:
Originally Posted by loofou
I tested the RC10 and could use it quite nicely. Now we still need to figure out why the macros throw errors after RC 10 (need to confirm later which update it was exactly that broke the macros)
|
I've done some significant updates in the macros since RC10, almost completely rewriting them. If you let me know what the specific error is and when it's coming up I may be able to figure something out.