10.2.2: Decimal places seperator error at importing data

Clarke

Hi all, 

I have a quick NOOB question. 

As my browser is not set on US standards - I have some trouble when importing files that use "." instead of ","
For decimal places. 

The result is if I import numbers that use "." as decimal seperator it gets treated as thousand seperator.
So it get's displayed as $500.500 (fivethousand fivehundred) instead of $500,50  (fivehundred and fifty cents)

When importing the data I do not see a option that takes this into account (see printscreen). 
Can someone help me resolve this?


Please see screenshots attached 
IST result = my current result 
SOLL result= the result as it should be

SOLL_results__145091.png

Import_options_145091.png

Source_file_145091.png

IST_result__145091.png

wskagegard

Hi,

 

You can choose this under file options. It's the pop up when you upload a new file. You can also change an existing file by clicking Edit file.