Convert fields from String to INT or Fixed Decimal

Kristy119

I have data that has numbers stored as text.  Some numbers need to be stored as a whole number (191); some numbers need to be stored as a fixed decimal (1.9548).

I tried to use the Multi-Field Formula, but for some reason, it is not taking the "ToNumber" expression.

I selected the 2 fields that need to be converted from "Text" to Int32, using the expression ToNumber([_CurrentField_]), but the output still shows the data fields as strings.  

I have not attempted using the Multi-Field Formula on fields that need to be converted from text to Fixed Decimal because I want to get the conversion to Int32 working first.

What am I missing in my Expression?

Thank you,

Kristy

Luke_C

Hi @Kristy119 

Please share the configuration of your multifield tool. By default it will create new columns off to the right that you may not be seeing. To keep the data in your original fields, you need to uncheck the copy fields box and check the box to change the datatype.