Excel Format Custom as "00000000" on Load

[#1]

Hi Experts

I am loading from an Excel file where 1 of the columns has a data validation of [Number between 930000 and 999999999] , there is then a custom format on the cell as '00000000', so basically all numbers are 8 digits long and if a shorter number is typed in , preceding zeros will be added.

When I load this column ([Account]) into QV it is loading as just the text value , so no preceding zeros,

Is it possible to add them again as part of the script , I tried text(Account) and variations

But I cant quite get it

Any suggestions greatly appreciated

Thanks

A

[CELAMBARASAN · Accepted solution]

Hi,

     Try with Num function.

     Num([Account],'00000000')

Celambarasan

[#3]

Thanks

It works !!