![]() |
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? |
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