Thread: Make Day CAPS In Custom Date Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Make Day CAPS In Custom Date Format
You need to use the Upper function, as in:
=UPPER(TEXT(A1,"hh:mm ddd dd.mm.yy"))

Regards,
Fred

"robzrob" wrote in message
...
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.

Reply With QuoteReply With Quote