Answers.com > Wiki Answers > Categories > Technology > Software and Applications (non-game) > Office Applications > Microsoft Excel > How do you format Excel to show military time when you type in the hour and minute?

How do you format Excel to show military time when you type in the hour and minute?

In: Microsoft Excel [Edit categories]

Answer:

Answer

Select the cell or the column you want to change the format of time on. Right click to bring up the dialog menu, then click on "Format Cells..."

Next Click on the Category Time
Then Select within Type : The military time from the examples given

First answer by Brountre. Last edit by Brountre. Contributor trust: 39 [recommend contributor ]. Question popularity: 6 [recommend question].

[report abuse]

	Why is it easier to use databases on Microsoft Access rather than Microsoft Excel?	Answer it!
	How do you score maximum marks in word and excel?	Answer it!
	What is the IF function used for in Microsoft excel?	Answer it!
	Where can you get worksheets for electricity for grade one?	Answer it!
	What is it called when you change the contents of a cell in excel?	Answer it!