View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laura Laura is offline
external usenet poster
 
Posts: 77
Default entering timecode into cells

I'm trying to enter metadata for video assets. When I enter "35:55" for 35
minutes and 55 seconds, it keeps being changed to a fraction or a date or
sometimes "0:35:55". I've tried formatting the cells to general or MM:SS, but
it won't work

Does anyone know what to select when entering TRTs for tapes?

Thanks!