Convert text to number

[whubbard88]

I have an output file that is returning a few columns, one with numbers in them. The problem I am encountering is that the column with numbers is coming out as text. Is there an option to have the output file have the column with numbers return numbers instead of text format? 

[binuacs]

@whubbard88 The value of the cell D2 is string type(2022-05 YTD (RC), I think that's why you are getting the string data type for this field

[Jay-RDC]

You can simply use a select tool and change the data type

[whubbard88]

Hi and thank you for responding! This is what I have right now selected, is there a different type that I should have? 

[Jay-RDC · Accepted solution]

Yes. Try to change it to int or fixed decimal. You can also parse 2022-05 YTD using text to column to separate the string and use auto field tool or select tool to change the data type.

[whubbard88 · Accepted solution]

Thank you! I don't think I did exactly what you did, but I changed the type to Double instead of V_string and it seemed to have fixed the problem. 

What a great help you were !! 

[Jay-RDC]

Awesome!