Power Query (Excel) cannot return the correct values for one column of a number of spreadsheets

[Garyeuph]

Hi,

I am trying to merge a large number of spreadsheets - all identical format and layout.

One of the columns in Excel has the data is as equations - similar to '=1345/100'.  The column in Excel is formatted as General Number

PAD always ends up interpreting this as the number 4 (All other columns come through as expected)

Any ideas as to why this may be happening?

Many thanks

[Garyeuph · Accepted solution]

Looks like posting an issue helps you find the solution

Turns out the input spreadsheets were generated by another programme - simply opening them all and just saving them removes the error - so just need to adjust my workflow slightly

[v-cgao-msft]

Hi @Garyeuph ,

Thanks for sharing and please consider marking your answer as a solution to help more people.

Best Regards,
Gao
Community Support Team