This post explains how to fix ‘ DataFormat.Error: We couldn’t convert to Number ‘. Working with data in Power Query, whether in Excel or Power BI, can streamline analysis and reporting.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.