Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Garyeuph
New Member

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

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

1 ACCEPTED SOLUTION
Garyeuph
New Member

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

View solution in original post

2 REPLIES 2
Garyeuph
New Member

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

Hi @Garyeuph ,

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

 

Best Regards,
Gao

Community Support Team

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors