This content has been marked as final. Show 2 replies
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