View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Dates - Display in CAPS

Hi Benjamin,

Not with formatting, but with a formula like

=UPPER(TEXT(TODAY(),"ddd mmmm dd yyyy"))

--
Kind regards,

Niek Otten

"Benjamin" wrote in message
...
When using date formulas and displaying the Month in letters is there a
way
to make the month letters be in ALL CAPS?
--
Benjamin