Can you enter date and time into a cell like this, I want to be able to
enter the time in military format without the colon..... ex.(dd/mm/yyyy
0800)


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=562056

Try it like this:

Enter in the cell you need the Military date and time in as:

=NOW()

Then format it as:

dd/mm/yyyy hhmm

The result is:

18/Jul/2006 0630

Results of date and time will vary from computer to computer.


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=562056

"patele" wrote in
message ...

Try it like this:

Enter in the cell you need the Military date and time in as:

=NOW()

Then format it as:

dd/mm/yyyy hhmm

The result is:

18/Jul/2006 0630

Results of date and time will vary from computer to computer.

That format would probably give 18/07/2006 0630

If you want 18/Jul/2006 0630 try dd/mmm/yyyy hhmm
--
David Biddulph

Thanks for covering my back David!


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=562056