I have list of start times that have been entered in the format 10.01 etc I need them to be in time format in order to use them in a spreadsheet to produce an event schedule, is there an easy way to convert the whole column so it reads 10:01 etc without overtyping it all, I tried to just change the cell format but this changes the value to :14 and so on.
Thanks
Bookmarks