In xl2003 menus:

Tools|autocorrect Options|Autocorrect tab
Add an entry to correct . (dot) with : (colon)

Remember to remove it when you're done.

And be aware that those autocorrect entries affect all the programs in the
Office Suite.

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?

--

Dave Peterson