Forum Discussion
donjolove
May 11, 2018Copper Contributor
XL
How do I format a column for time in the 24 hour (military) format??!! It is not a choice in the formattimg menu. HELP
Haytham Amairah
May 11, 2018Silver Contributor
Hi,
Follow these steps to apply the military time format:
- Select the targeted column
- Press Ctrl+1 to open the Format Cells dialog box
- From Category list box, select Time.
- On the right-hand side, find the military time format, select it, and then hit OK.
Regards