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.
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