9 Replies Latest reply: Aug 29, 2012 5:33 AM by P Spier RSS

    timecode format after importing excel-files

    grafikwienholt™

      I've got a tricky question, but maybe someone is master of tables and knows how to deal with this:


      i'm workin on a tram schedule and have got to import lots of ecel tables. the format of the timecode, which is correctly included in

      excel has to be HH:MM. By importing the files indesign kills the forestanding 0 for all single-digit timecodes. so it transforms 07:40 to 7:40,

      which i can't use. so my question: is there any way to import the timecodes in the right format or otherwise any way to add the missing 0

      afterwards for round about 2000 cells? hope anybody has an idea.

       

      best regards – tobias

       

       

       

       

       

      ------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ ----------------

       

       

       

      i got:

       

      got.png

       

       

      i need:

       

      need.png