Forum Discussion
Solved
Convert text to number
What is the proper syntax to convert a text into a number format? I need to convert some import data(xls) that for some reason is coming accross as text instead of a number. It is formatted in x...
Couple different methods, you can choose number or currency from the Modeling tab in the Data Type section and it will generally convert it just fine. There is also the VALUE function:
https://msdn.microsoft.com/en-us/library/ee634584.aspx
If the the values of the column took the format of text with currency such as positive values $123,23.05 or negative values ($32,256.09), I would replace the character $ by 0 by right clicking the column and selcting "replace values".
Then you can now convert the format of resulting column to a fixed decimal number.