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

    timecode format after importing excel-files


      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:





      i need: