How do I set up military time? When I enter "0800" and enter, it converts to
"800".

You could format the cell as text, or enter '0800. You can still add,
subtract, etc in that format.

Carole O

"Tiggerco" wrote:

How do I set up military time? When I enter "0800" and enter, it converts to
"800".

Working with numbers that are text can be difficult. Working with times becomes
even more difficult.



Carole O wrote:

You could format the cell as text, or enter '0800. You can still add,
subtract, etc in that format.

Carole O

"Tiggerco" wrote:

How do I set up military time? When I enter "0800" and enter, it converts to
"800".

--

Dave Peterson

I would enter the time as time.

But then format that cell as: hhmm

If you really want to avoid typing that colon, Chip Pearson has some VBA code
that you may want to tweak:

http://www.cpearson.com/excel/DateTimeEntry.htm

Tiggerco wrote:

How do I set up military time? When I enter "0800" and enter, it converts to
"800".

--

Dave Peterson

Enter 08:00
--
David Biddulph

"Tiggerco" wrote in message
...
How do I set up military time? When I enter "0800" and enter, it converts
to
"800".