Converting numbers stored as text to numbers

[iamkamara_jpm]

As the title suggests, need help converting numbers stored as text in a column into numbers

Tried a few things but wanted to know the easiest way to do this? I know there's a text to column tool in Alteryx but it doesn't seem to work the same way it does in Excel

Sample Data

Note for the first line item, the text to column in excel removes the leading zero, which is also want I want Alteryx to do

Current Data	Desired Data Output
07383834	7383834
84843435	84843435

[binuacs]

@iamkamara_jpm 

[iamkamara_jpm]

thanks for the reply. I don't just want to trim the leading zeros, i want to convert all the values currently stored as text in one column to numbers, which will also procedurally take care of the leading zeros. 

[iamkamara_jpm]

thanks for the reply. I don't just want to trim the leading zeros, i want to convert all the values currently stored as text in one column to numbers, which will also procedurally take care of the leading zeros. 

[binuacs · Accepted solution]

@iamkamara_jpm use toNumber function and change datatype to double