format time

[kefee85]

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

 

[RagDyer]

Custom format:

hhmm

 

[smartin]

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

Cells | Format | Number | Custom, enter hhmm for the type.

 

[kefee85]

Thanks.....

Custom format:

hhmm

 

[Gord Dibben]

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

 

[Ragdyer]

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