Thread: Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default Time

Format Custom HH:MM

HTH

Die_Another_Day
changetires wrote:
I want my date and time to display as military time input and eliminate
those pesky seconds digits that keep showing up? How do I do this?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=560442