Convert text to number when submitted by a Microsoft Form

[LearnNewThings]

I have a Microsoft form that is writing data to an Excel spreadsheet in SharePoint. The for adds a new row when a submission is added. However, the data is submitted as text. I would like to be able to automatically convert to numbers so that my dashboards work appropriately. Does anyone know of a clean solution to do this?

 

[ExcelToDAX]

Can't you just change the type to Whole Number or Decimal Number in Power Query? If you are using Power Automate to populate the spreadsheet, you can use the expression int() in the column that you want to be a number as well.