Quote:
Originally Posted by loofou
About the , and . issue: My windows is set up to UK settings, but my keyboard uses the German layout. I had problems in the past with the decimal points being commas, so I set my region to UK with decimal dots. It might still be related, though, I'll investigate further on another machine with complete native UK settings for everything and see if this changes anything.
|
In the sheet you uploaded I see multiple places where a text string conversion of a number which should be outputting a "0" is outputting a ",0" which makes me seriously suspect regional setting issues. Most of those text strings are set up to output numbers as text in the "#,##0" format, so with a regional separator of a comma it's going to interpret that comma as the decimal separator and output ",0"