2 Replies Latest reply: Apr 18, 2012 6:15 AM by Anne Duffy RSS

    Excel Format Custom as "00000000" on Load

      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