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

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

<Format<Cells
Go to the "Number" tab
Click on "Custom"
Enter "0000" (without the quotes)

--
Regards,
Dave


"exsam21" wrote:


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

Thank you very much!


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

But 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
wrote:


Thank you very much!

So one might want to use Chip Pearson's
Times, Quick Entry (military time)
http://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.
http://www.cpearson.com/excel/datetime.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Gord Dibben" <gorddibbATshawDOTca wrote ...
But just remember...........it will look like 0753 but is not a not a real time,
only the number 753.