View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barry Barry is offline
external usenet poster
 
Posts: 11
Default 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