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

       

      Thanks

      A