Hi!
An alternative to the VBA solution is to *TEMPORARILY* set
AutoCorrect to replace a period "." with the colon ":" and
enter the "times" like 12.34. You would have enter the
times in a 24 hr clock format but can reformat them after
they've all been entered.
This is lots faster and easier than using the 1 2 shift
colon 3 4 space P M method.
Just remember to reset AutoCorrect after you're done.
Biff
-----Original Message-----
I am trying to type in 12:34 as 1234(for example) and
have the format convert
it back to 12:34 Is there a way of formatting this
conversion? I will need it
to be a time format since it is a time card key entry.
Thanks
--
Danlinksman
.
|