Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
66
Views
Topic starter
Hello,
I have some problems converting numbers from the attached csv.
The files named screen shows that when I upload values into power query my initial numer -47.5 is converted in -475; I noticed problems just with number like this, with integer numbers everithing is fine. I also check in advanced option but my decimal separator is set with ".".
Could you help me with this.
Posted : 19/03/2019 12:44 pm
Hi Stefano,
You checked in Advanced options in Excel I guess?
Check the regional settings in: Control Panel>Clock and Region>Change Date, time and number formats>Formats tab-Additional settings.
Posted : 20/03/2019 6:59 am
