Thread: format time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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?