G Guest Nov 10, 2006 #1 How do I set up military time? When I enter "0800" and enter, it converts to "800".
G Guest Nov 10, 2006 #2 You could format the cell as text, or enter '0800. You can still add, subtract, etc in that format. Carole O
You could format the cell as text, or enter '0800. You can still add, subtract, etc in that format. Carole O
D Dave Peterson Nov 10, 2006 #3 Working with numbers that are text can be difficult. Working with times becomes even more difficult.
D Dave Peterson Nov 10, 2006 #4 I would enter the time as time. But then format that cell as: hhmm If you really want to avoid typing that colon, Chip Pearson has some VBA code that you may want to tweak: http://www.cpearson.com/excel/DateTimeEntry.htm
I would enter the time as time. But then format that cell as: hhmm If you really want to avoid typing that colon, Chip Pearson has some VBA code that you may want to tweak: http://www.cpearson.com/excel/DateTimeEntry.htm
