Power Query removes hidden decimals

[deLockloire]

Hi,

I'd like to load in two columns of inflation data from this source: https://statisztika.mnb.hu/timeseries/hu0201_fogyarindex.xls
The exact range I'd like to get is 'éves átlagos'!A39:B68. Column B contains decimal numbers with up to 12 decimal places, but the table is set to display only 1 decimal place. Now whatever I do, Power Query in excel only loads in that 1 decimal place. If I change the data type to decimal, then all the numbers give me an error. If I keep them az text, I only get 1 decimal. The column contains a variety of data types, so Power Query recognizes it as text by default. How can I get the full number? What am I doing wrong?

Also, how can I load this data to continue another table that has inflation data for years before the starting year of this particular table?

Thanks for any tips!
deL

 

[GraH]

Download the file, save as .xlsx.
Do your PQ stuff.

The issue is the excel format .xls. PQ seems to read the data as displayed, not as stored, whereas with .xlsx that's not the case.

 

[deLockloire]

It's a good tip. However, the point is to automate this without having to manually do anything. By downloading and resaving, I might as well just copy paste the info. Any other tip? Of course, if this is a known limitation of PQ, then it is also good to know not to waste any more time on this. In any case, thank you for your answer!

 

[GraH]

Changing the format to general while keeping the .xls format and the decimals do show up.
Saying this is a limitation of Power Query is perhaps debatable. I believe the same happens with an .xlsb-format.

 

[deLockloire]

So mine is set to text by default. How do I change it to general? I don't see that option.

 

[GraH]

You need do this in the excel file not in PQ.
So it's not an effective solution.

 

[deLockloire]

Are there any other ideas I could try?