Trying to get my CVS data report to play with my excel formulas, but when Sambapos gives me an amount in the thousands it plays out as 12 345 instead of 12345.
I know the excel local settings are also to blame here, but i’m wandering if someone has delt with this before as I could see anything while searching for answers.
To be clear: my excel formulas do not work with the space in the thousands. when i remove the space it works perfectly. (Look at screenshot and waffel is only 150 so formula works but not on thousands with a space in)
I have added some screen shot for clarity. My excel integer is ;