Ed

FormatCellsCustom enter hh:mm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"changetires"
wrote in message
...

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