Wrong display numbers with decimal signs

[mechanix85]

Hi,

I get data from Excel, which contains decimal data (different number of decimal places). to get some unique key, I need to combine the text and decimal values into one column. but power query incorrectly imports decimal values, adding additional characters. examples in the screenshots.

PS: this problem is observed if the data table is not in the same book where the request is made

[v-chuncz-msft]

@mechanix85,

It might be caused by the data souce. You may use Number.Round to deal with it.

[mechanix85]

@v-chuncz-msft,

but how do I round the number if I do not know what number of decimal places will be?

[v-chuncz-msft · Accepted solution]

@mechanix85,

Check the custom number format.

https://support.office.com/en-us/article/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-...

[mechanix85]

@v-chuncz-msft

helped change the format of the number in the source file to text