format time
 

I need to format a column to display the time as 0130...without the colon.
Is there an easy way to do this?

format time
 

Custom format:

hhmm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kefee85" wrote in message
...
I need to format a column to display the time as 0130...without the colon.
Is there an easy way to do this?

format time
 

Thanks.....

"RagDyer" wrote:

Custom format:

hhmm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kefee85" wrote in message
...
I need to format a column to display the time as 0130...without the colon.
Is there an easy way to do this?

format time
 

Custom Format of hhmm

Note: formatting the cells will display existing time as 0130 but in order
to enter a valid time you still have to type the colon.


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 14:55:01 -0700, kefee85
wrote:

I need to format a column to display the time as 0130...without the colon.
Is there an easy way to do this?

format time
 

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kefee85" wrote in message
...
Thanks.....

"RagDyer" wrote:

Custom format:

hhmm
--
HTH,

RD


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

--------------------------------------------------------------------------
-
"kefee85" wrote in message
...
I need to format a column to display the time as 0130...without the
colon.
Is there an easy way to do this?