Jeffrey

Excel doesn't work that way.

If you need real times you must enter the time with colons 06:45 or use event
code which is available at Chip Pearson's site.

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

Alternative if you are not using the times for calculations just preface with an
apostrophe.

i.e. '0645 You won't see the apsostrophe in the cell.


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 19:00:08 -0800, Jeffery
wrote:

Hi all. I'm new to this, firgured someone here might be able to answer my
question. I have Office 2007. I'm trying to write a report for my science
class and have to enter the time in mililtary format. However when ever I
enter the time as 0645, it automatically changes it to 645. This is not
correct. I have tried just about everything I can find - but it won't stop
this auto converting... anyone know how to make it display what I type in and
not change it to how it wants it to read?