Convert Account Number to General Format in Excel to allow Vlookup

[ankush-agrawal]

Hello Reader,

I have few account numbers as below in my output.

1010000000

131210005I

299110000L

1110000A00

When extracting to excel as output, the datatype is V_W String. However, this is creating vlookup issue for user and they need to first convert it into number format and then apply vlookup.

Is there a way in alteryx to solve this problem?

I tried to convert it into double format but this deletes the letter inside the 10 digit account number, giving incorrect data like

131210005I

299110000L

1110000A00

[binu_acs]

@ankush-agrawal when you convert these account numbers to number format in excel what is the output you are getting? 

[Komal_singla1]

before doing vlookup convert the data from number to text using text to column in the original excel file and then try

[ankush-agrawal]

I get the general format in excel, let me show you sample. 

U can see the example of Account 1010000000.

One is after converting to Number and other is before (with some Green Mark at the top right, meaning the data is in text format)

This is not good for vlookup.

[ankush-agrawal]

Komal, it is the other way around. 

My output is from Alteryx to Excel and then I am using the excel for other different purpose. So, rather than manually changing the data type in excel, I will prefer something if available in Alteryx for this and user can directly work on it, rather than spending time.