close

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?


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

quot;Katquot; wrote:

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()