K
kefee85
I need to format a column to display the time as 0130...without the colon.
Is there an easy way to do this?
Is there an easy way to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyer
Custom format:
hhmm
hhmm
S
smartin
kefee85 said: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.
K
kefee85
G
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
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
R
Ragdyer
You're welcome, and thank you for the feed-back.