How about using the giant + key on the number keypad?

Then you can do your data entry and when you're done, select that range and do a
single:

Edit|replace
what: + (Plus key)
with: : (colon)
replace all

Using the hypen caused my entries to change to dates (if they could be
interpreted as dates).

houghi wrote:

I have recieved a huge list on paper with a LOT of times on it in the
format 12:34:56. Unfortunatly it is not possible to recieve the list
digitaly.

I need to enter these and the thing that disturbes me most is that I
have to type the : which is awkward with the <shift<;

Is there a way that I can use the - key on the numeric keyboard to
display the : in excel? That would speed things up a LOT for me.

I have searched googe and was not able to find anything, so I am not
sure wether this is possible.

houghi
--
Listen do you hear them drawing near in their search for the sinners?
Feeding on the power of our fear and the evil within us.
Incarnation of Satan's creation of all that we dread.
When the demons arrive those alive would be better off dead!

--

Dave Peterson