Remove AM PM

Is there a way to remove the AM & PM in teh time to just read 5:00 not 5:00 AM

Format the cell as hh:mm ?

Regards

Trevor


"gennario" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to remove the AM & PM in teh time to just read 5:00 not
> 5:00 AM

I did that but the am is still in the formula bar

"Trevor Shuttleworth" wrote:

> Format the cell as hh:mm ?
>
> Regards
>
> Trevor
>
>
> "gennario" <[email protected]> wrote in message
> news:[email protected]...
> > Is there a way to remove the AM & PM in teh time to just read 5:00 not
> > 5:00 AM
>
>
>

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.

On Thu, 29 Sep 2005 16:00:01 -0700, "gennario"
<[email protected]> wrote:

>I did that but the am is still in the formula bar
>
>"Trevor Shuttleworth" wrote:
>
>> Format the cell as hh:mm ?
>>
>> Regards
>>
>> Trevor
>>
>>
>> "gennario" <[email protected]> wrote in message
>> news:[email protected]...
>> > Is there a way to remove the AM & PM in teh time to just read 5:00 not
>> > 5:00 AM
>>
>>
>>

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>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Myrna Larson" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
> On Thu, 29 Sep 2005 16:00:01 -0700, "gennario"
> <[email protected]> wrote:
>
> >I did that but the am is still in the formula bar
> >
> >"Trevor Shuttleworth" wrote:
> >
> >> Format the cell as hh:mm ?
> >>
> >> Regards
> >>
> >> Trevor
> >>
> >>
> >> "gennario" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Is there a way to remove the AM & PM in teh time to just read 5:00
not
> >> > 5:00 AM
> >>
> >>
> >>

Thanks for the correction, Rag.

On Thu, 29 Sep 2005 20:07:25 -0700, "RagDyer" <[email protected]> wrote:

>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>