Forum Discussion
Solved
Convert text to number
Hello I have a column of numbers that was imported as a text. I wanted that changed to a Fixed Decimal Number. This needed to be the case in 2 columns. In both columns every cell converted a...
Replace "%" before to convert to number the columns.
A guide:
Step 1:Step 1: Edit QueryStep 2: First row as headerStep 3: Delete first rowStep 4: Replace %Step 5: Convert to NumberStep 6: Ready
Thank you very much for your response!
Here is a picture of me trying to do just that but I keep getting an error message saying that I need to enter a numerical value.
JGSmith123 wrote:
Thank you very much for your response!
Here is a picture of me trying to do just that but I keep getting an error message saying that I need to enter a numerical value.
Undo the "Changed Type" step (namely revert this column from decimal to text) and then replace the "%" with blank.
I've also noticed that there're more invalid rows appended. Do remember to uncheck them.