Thread: please help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default please help

in column F and about 700+ cells down, are times that where entered like
this...
010754. But the times were meant to be entered as such... 01:07:54. The
colons are missing. Is there a quick and easy way to somehow enter the
colons in all the times, without having to do it manually for each time?

Thanks,
Brian