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?

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

    software

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

    E-mail轉寄