Forum Discussion
How to convert Data type from Text to Number
I am trying to change this column to a data type number. The values are numbers, I've trimmed the values but whenever I try to convert to number, it still throws an error.
create a new column and write the following formula
Number.From(
Text.Select([ON HAND QUANTITY],{"0".."9"}))