Is there a way of removing the apostrophe before numbers?

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!