Changing datatype of a column

[#1]

I am trying to change a numeric column to character using column info window. But it changes back to numeric automatically once I change it to character value. Can someone help me in fixing this issue?

[#2]

hi anuashka0​,

this probably happens since the column contains at least one character in one row. you will need to delete it or change it to a numeric value before enforcing the change of the column type.

ron

[#3 · Accepted solution]

I believe you will find the column you are trying to change has a formula that is setting it's value.  To be able to change this value, you will need to go to the Column Info for the column, click on the formula column property, and then click on remove.  This will not remove the values from the column, but will just remove the formula.  The values in the column have now become just regular numeric values.  Now you will be able to change the data type to character.

[#4]

Thank You Jim. That was precisely the problem I was facing. Your suggestion helped me fix the issue!! Thanks