If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display the date in an unusual format
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 |
Thread Tools | |
Display Modes | |
|
|