You’re offline. This is a read only version of the page.
Announcements
1
I have designed an MS form to collect numeric data in an Excel spreadsheet. Data is stored in Excel as text. The raw data is linked to Pivot tables and are unable to calculate the numbers in a text format. Pivot tables only work if I go in and manually go into Excel and change the format to number. Would like to use Power Automate.
Try using the Power Automate conversion expressions such as int() and float() to convert the text that you receive from Excel into a number.
Share
Report
All responses (
Answers (
