View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default Make Day CAPS In Custom Date Format

I've got a cell formatted thus: hh:mm ddd dd.mm.yy which returns 19:20
Thu 25.02.10. I want 19:20 THU 25.02.10, ie the day in caps.