| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Military time trouble | Excel Worksheet Functions | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| Time and motion chart | Charts and Charting in Excel | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
Hybrid Mode
