Forum

Notifications
Clear all

Numbers showing as text in responses from MS forms

3 Posts
2 Users
0 Reactions
301 Views
(@stephenn)
Posts: 2
New Member
Topic starter
 

I have recently created a MS Form from Excel on line to collect water meter readings. I have created formula in the Excel document making use of the data collected in the form. The challenge I am having is that the numbers appear as text (eg. '345 instead of 345) and don't work in my formula unless I manually convert them to numbers (I know I could create another column to automate the conversion, but that is an extra step I would rather avoid).  

The survey questions have been set to capture numbers only.

Is there another setting I am missing somewhere?

 

Thanks 

Stephen

 
Posted : 31/05/2020 9:49 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Stephen, 

I think this is a bug and have escalated it to Microsoft. In the meantime you can add your extra column or use Power Query to automate fixing the data.

Mynda

 
Posted : 01/06/2020 12:28 am
(@stephenn)
Posts: 2
New Member
Topic starter
 

Thank you for your speedy response.

 
Posted : 01/06/2020 3:40 pm
Share: