E
exsam21
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.
and I want the cell to display 0753 when I enter 753. Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
format as 0000, Format>Cells>Custom.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
D
David Billigmeier
<Format><Cells>
Go to the "Number" tab
Click on "Custom"
Enter "0000" (without the quotes)
Go to the "Number" tab
Click on "Custom"
Enter "0000" (without the quotes)
E
exsam21
Thank you very much
G
Gord Dibben
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
only the number 753.
Gord Dibben MS Excel MVP
D
David McRitchie
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
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