Numbers stored as text conversion

Question

Hi All,

I have data in a specific column which has both numbers (which are stored as text) and text.

I want to convert the numbers which are stored as text to number format. I do not want to create separate column for doing the same.

Any way I can do the same.

Thanks

Vishal

rohit782192 · Answer

What is the Exact Solution. Have you try to figure out the same.

echuong1 · Answer

If you use tonumber() it will only convert the numeric values for the expression. Everything else will have a conversion error, so it wouldn't be factored in/impacted.

However, for vlookups that is replicated through a Join tool. Ideally you'd want to make the field that you're doing the vlookup to match in datatype. I suggest changing both to strings, and then doing the vlookup. Whether the value is a number or a string won't matter.

F600314 · Answer

Hi Thanks@enchuong1.

If i use tonumber(), then it will convert only number stored as text and would not impact the existing text field?

I need to perform vlookup formula on this column.