ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does A8 come up in military time? (https://www.excelbanter.com/excel-discussion-misc-queries/75708-why-does-a8-come-up-military-time.html)

Kat

Why does A8 come up in military time?
 
When I type the time in all the other cells it comes out fine. When I tried
typing the time in cell A8 it came back as military time. Why does this
happen and how can I get it to type in as regular time?

Rich Mcc

Why does A8 come up in military time?
 

change the cell format to display the data the way you want it ,, right click
format cell....

if you goto custom and have the time as H:mm instead of HH:mm will give you
12 hrs clock

"Kat" wrote:

When I type the time in all the other cells it comes out fine. When I tried
typing the time in cell A8 it came back as military time. Why does this
happen and how can I get it to type in as regular time?



All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com