LearnNewThings
New Member
- Joined
- Aug 27, 2019
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
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?