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?