"Convert to Number" without affecting other cells?

[skeen503979]

Hello!

Question:

How can I "convert to number" without affecting other cells that contain letters?

Background:

I have a huge list of SKUs I'm trying to use as a reference (Vlookup in Excel), however, some SKUs won't populate because they must first be converted to a number.  Currently, in Alteryx the data shows to be "V_String" type.  Normally I would just throw the Select tool up and switch to data type "Double", but in this case doing so removes other cells that contain letters.

[Emil_Kos]

Hi,

I believe you need to use tonumber function.

good luck!

[Qiu]

@skeen503979 
If I understand correct, eventually you will Number and String type of data in one column, which is not really possible, I think.
Can you use String data for VLookUp in Excel?