Thank you for the response. I've got it working via some vba code, but
appreciate your prompt reply.

"Sean Timmons" wrote:

You'll probably want to delete this once you are done..

Go to Tools - Autocorrect Options

Replace . with :


"harwookf" wrote:

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.