How to display a date

B

Barry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date issues 1
Convert Text to Date Month and Year 1
Specific Date from a Range 3
accepting most recent date across columns 10
Date format 8
Date Formating within a text cell 1
MM/YY Formatting date Entry AND Display 2
Formula not reading date format 3

Top