Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date format, NOT JUST DISPLAY !! | Excel Worksheet Functions | |||
How to display month only for date format? | Excel Worksheet Functions | |||
How to display month only for date format? | Excel Discussion (Misc queries) | |||
Unusual data format | Excel Worksheet Functions | |||
Format to display date as Quarter | Excel Discussion (Misc queries) |