It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

Hi!

Without entering either AM/PM, AM is the default. The only way to get around
it without entering PM is to use a 24 clock:

22:00

Technically, I guess you could use an event macro that adds 12 hours to the
time entered but that's out of my area of "expertise".

Biff

"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

type 22:00 and format it suitably


"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

After the time entry, enter a
<Spacep
then <Enter.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"R..VENKATARAMAN" wrote in message
...
type 22:00 and format it suitably


"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

Answered wrong post ... Sorry ! ! !
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"R..VENKATARAMAN" wrote in message
...
type 22:00 and format it suitably


"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter the
current time in a cell?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

Just an aside but do you know you can just use CTRL+SHIFT+ENTER
to enter the current time in a cell?

You can? You must have meant CTRL+SHIFT+:



"Ken Wright" wrote in message
...
Just an aside but do you know you can just use CTRL+SHIFT+ENTER
to enter the current time in a cell?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and
hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

LOL - Dohhhhhh!!!! Brain freeze time - Thanks for the catch Chip :-)

Regards
Ken....................

"Chip Pearson" wrote in message
...
Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter
the current time in a cell?

You can? You must have meant CTRL+SHIFT+:



"Ken Wright" wrote in message
...
Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter
the current time in a cell?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"GW" wrote in message
...

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

On Sun, 26 Feb 2006 13:48:01 -0000, "Ken Wright"
wrote:

Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter the
current time in a cell?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


Thanks, Ken. Yes, I knew that, but sometimes I forget to enter the
time and have to go back later to do it manually, hence the need to be
able to change the default.

Thanks to all.