If you want to do this on a regular basis you would be better off using an
event macro


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

--


Regards,


Peo Sjoblom

"harwookf" wrote in message
...
Hi
I would like to enter time into a timesheet using the decimal point
instead
of the colon as it makes it easier and quicker to type, however I still
want
it to display correctly with the colon.
For example - if I enter 12.35 I would like it to display as 12:35 so it
is
literally just changing the . to :
Many thanks in advance.