View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Change . to represent :

And for one final thought on the matter... If you are not averse to using
macros... Check out this link:

http://www.cpearson.com/excel/DateTimeEntry.htm
--
HTH...

Jim Thomlinson


"DB74" wrote:

I am 10-keying times into a spread sheet. Is there a way to make a .
represent : for time so I can 10-key it faster?