How to display a date
 

I would like to display a date time in the format of:

20100331213045 etc..

the 2010 being the year
the 03 being the month
the 31 being the day
213045 being the time hours minutes and seconds in military format.

this would look to cell H3 for the date time entry to display

I'm sure there's a formula there somewhere... LOL

Thanks for your help!


Barry

How to display a date
 

Date and time of: 31/03/2010 9:30:45 PM

Custom format the holding cell to: yyyymmddhhmmss
http://www.ozgrid.com/Excel/CustomFormats.htm



--
Regards
Dave Hawley
www.ozgrid.com


"Barry" wrote in message
...
I would like to display a date time in the format of:

20100331213045 etc..

the 2010 being the year
the 03 being the month
the 31 being the day
213045 being the time hours minutes and seconds in military format.

this would look to cell H3 for the date time entry to display

I'm sure there's a formula there somewhere... LOL

Thanks for your help!


Barry