Remove AM PM

Format the cell as hh:mm ?

Regards

Trevor


"gennario" <gennario@discussions.microsoft.com> wrote in message
news:DD18521C-A463-4897-8E7A-34BFBB1D80E0@microsoft.com...
> 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" <gennario@discussions.microsoft.com> wrote in message
> news:DD18521C-A463-4897-8E7A-34BFBB1D80E0@microsoft.com...
> > 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"
<gennario@discussions.microsoft.com> 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" <gennario@discussions.microsoft.com> wrote in message
>> news:DD18521C-A463-4897-8E7A-34BFBB1D80E0@microsoft.com...
>> > 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" <anonymous@discussions.microsoft.com> wrote in message
news:f74pj1tv771c5d6vfmcb4b6cnv9s36736d@4ax.com...
> 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"
> <gennario@discussions.microsoft.com> 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" <gennario@discussions.microsoft.com> wrote in message
> >> news:DD18521C-A463-4897-8E7A-34BFBB1D80E0@microsoft.com...
> >> > 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" <RagDyer@cutoutmsn.com> 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>