Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try with Num function.
Num([Account],'00000000')
Celambarasan
Thanks
It works !!