software

How do I keep a leading quot;0quot;? 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: www.excelforum.com/member.php...oamp;userid=22666
View this thread: www.excelforum.com/showthread...hreadid=502581format as 0000, Formatgt;Cellsgt;Custom.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;exsam21quot; gt; wrote in
message ...
gt;
gt; How do I keep a leading quot;0quot;? For example, I need to enter military time
gt; and I want the cell to display 0753 when I enter 753. Thanks.
gt;
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile:
www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=502581
gt;
lt;Formatgt;lt;Cellsgt;
Go to the quot;Numberquot; tab
Click on quot;Customquot;
Enter quot;0000quot; (without the quotes)

--
Regards,
Davequot;exsam21quot; wrote:

gt;
gt; How do I keep a leading quot;0quot;? For example, I need to enter military time
gt; and I want the cell to display 0753 when I enter 753. Thanks.
gt;
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=502581
gt;
gt;


Thank you very much!--
exsam21
------------------------------------------------------------------------
exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
View this thread: www.excelforum.com/showthread...hreadid=502581But just remember...........it will look like 0753 but is not a not a real time,
only the number 753.Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 12:48:41 -0600, exsam21
gt; wrote:

gt;
gt;Thank you very much!So one might want to use Chip Pearson's
Times, Quick Entry (military time)
www.cpearson.com/excel/DateTimeEntry.htm

Or maybe not, I suppose that is the way they are actually to appear
although you could format as hhmm under custom format.

More information on working with dates and times, if you have
dates and times not just four digit numbers.
www.cpearson.com/excel/datetime.htm
www.mvps.org/dmcritchie/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htmquot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote ...
gt; But just remember...........it will look like 0753 but is not a not a real time,
gt; only the number 753.