question about entering date and time

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)

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.2b52kf_1153222505.787@excelforum-nospam.com> wrote in
message news:patele.2b52kf_1153222505.787@excelforum-nospam.com...
>
> 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!