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

Countdown macro - display settings 2
Display the date in an unusual format 1
VBA - exporting serial letters to single documents 0
Excel date question 0
Convert Text to Date Month and Year 1
Autofill Date in Word 15.33 for Mac 0
Date Calculation - Astro Calculation 0
Date issues 1

Top