G
gennario
Is there a way to remove the AM & PM in teh time to just read 5:00 not 5:00 AM
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Trevor Shuttleworth
Format the cell as hh:mm ?
Regards
Trevor
Regards
Trevor
G
gennario
I did that but the am is still in the formula bar
M
Myrna Larson
There's no way to change what you see in the formula bar. Buy why would you
want to? You would have no way of differentiating 5 AM and 5 PM.
want to? You would have no way of differentiating 5 AM and 5 PM.
R
RagDyer
Actually you could ... if you went into the regional settings.
You could pick the Time option with the uppercase "H".
Of course, you might consider that cheating, because that does put you into
24 hour mode, but the formula bar will display without the AM or PM.<bg>
You could pick the Time option with the uppercase "H".
Of course, you might consider that cheating, because that does put you into
24 hour mode, but the formula bar will display without the AM or PM.<bg>
M
Myrna Larson
Thanks for the correction, Rag.