Leading 0's

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.

format as 0000, Format>Cells>Custom.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"exsam21" <exsam21.21uf40_1137609001.7138@excelforum-nospam.com> wrote in
message news:exsam21.21uf40_1137609001.7138@excelforum-nospam.com...
>
> 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!

<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
>
>

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
<exsam21.21ug1d_1137610211.2027@excelforum-nospam.com> 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.