timecode format after importing excel-files
Aug 28, 2012 5:42 AM
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:
