format as 0000, FormatCellsCustom.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"exsam21" wrote in
message ...

How do I keep a leading "0"? For example, I need to enter military time
and I want the cell to display 0753 when I enter 753. Thanks.


--
exsam21
------------------------------------------------------------------------
exsam21's Profile:
http://www.excelforum.com/member.php...o&userid=22666
View this thread: http://www.excelforum.com/showthread...hreadid=502581