Last answered:

11 Jun 2024

Posted on:

28 Jan 2023

1

Decimal dot not showing.

Haveing problem with importing exchange rates on import, rates are as they should be??!!

image.png

4 answers ( 0 marked as helpful)
Instructor
Posted on:

29 Jan 2023

0

Please make sure you change the data type to decimal number, Power Query may have imported this as a whole number

Posted on:

29 Jan 2023

0

Yes I did and it did not help, so I did it manually. If I changed type to decimal number I got 10.865,00

Instructor
Posted on:

29 Jan 2023

0

image.png

Posted on:

11 Jun 2024

0

It does not work to simply change the data type. What is the simplest work around here please?

Submit an answer