Change . to represent :

[DB74]

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?

 

[Gary''s Student]

hh:mm:ss is only 8 keys. What are the other two?

 

[Pete_UK]

Make a temporary entry into the Tools | Autocorrect table, so that .
gets converted into :

Ensure that you delete the entry when you are finished.

Hope this helps.

Pete

 

[Dave Peterson]

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.

 

[Niek Otten]

Look here too:

http://xldynamic.com/source/xld.QDEDownload.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?

 

[DB74]

Sorry... I am using a 10-key to enter the data and want to use the decimal to
represent :...

 

[Mike H]

you could use ~ as a delimeter and do an autocorrect
~ to : to eliminate the shift key and reduce it to 8 keys.

Mike

 

[Mike H]

no you couldn't because ~ requires a shift!! what about ` to :

 

[Pete_UK]

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

I didn't know that Dave - thanks for pointing it out.

Pete

 

[Tyro]

10-keying refers to the use of the numeric key pad to enter numbers. There
is no ":" on the keypad.

Tyro

 

[Jim Thomlinson]

And for one final thought on the matter... If you are not averse to using
macros... Check out this link:

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

 

[DB74]

Thanks for everyone's suggestions...
I was able to make a control box macro to do it...

Private Sub CheckBox1_Click()
If CheckBox1 Then
Application.AutoCorrect.AddReplacement What:=".", Replacement:=":"
Else
Application.AutoCorrect.DeleteReplacement What:="."
End If
End Sub

This seems to work well.