Thread: Formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sarajayne sarajayne is offline
external usenet poster
 
Posts: 2
Default Formula?

I have a column of numbers that I need to convert to hh:mm:ss ie 57 changed
to 00:00:57. I have 1567 entries and was hoping there was a way of doing it
rather than manually changing every entry!! Pls help!