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
1 Reply
- Haytham AmairahSilver 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