Display the date in an unusual format

B

Barry

I'm using Excel 2003 Sp3

I'd like to display the date entered in cell H3 in cell I3 in the following
format:

20100331215045

2010 year
03 month
31 day
2150 hour and minute
45 the seconds

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


Thanks in advance,

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

How to display a date 1
Excel Formula Bar Time Display Format 2
Date format 9
Specific Date from a Range 3
Date issues 1
Convert Text to Date Month and Year 1
MM/YY Formatting date Entry AND Display 2
Formula not reading date format 3

Top