Is there a way of removing the apostrophe before numbers?

04/30/21
Answered - Pending Review

We are using Microsoft forms to collect user's information on a NPS survey and the numbers are coming as text eliminating the possibility of run any mathematical function. Is there a formula that can be put in the column to automatically format the value to a number once the new row is created by the automated process coming from Microsoft office forms?

When the value is entered into the Text/Number type column in SS it looks like this '10

then I had to create another column to convert from text to number using =Value()

is a pain in the rear to have to do it for long survey or any other forms that will collect numbers.

Why SS does not have Number type value as column?

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    It is going to depend on how the form is being filled out. I have numbers submitted via form rather frequently with no issue.


    Are the formulas that un the metrics on these submissions on the same sheet or a separate sheet?

    thinkspi.com

  • same sheet

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    And what kind of formulas are you using? Are you able to provide a few examples of them? Are any of them using direct cell references to the columns such as [Column Name]@row?

    thinkspi.com

Sign In or Register to comment.