TIME

MONDLOC

New Member
Joined
Jan 23, 2004
Messages
4
I am inputting a lot of miltary time cells. Is there a way that i can set it up so that the colon will automatically appear when I enter the four digits? Thanks
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,118,074
Messages
5,570,048
Members
412,308
Latest member
cornelb
Top