ExcelBanter - Dates - Display in CAPS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Dates - Display in CAPS (https://www.excelbanter.com/excel-discussion-misc-queries/64756-dates-display-caps.html)

Benjamin

Dates - Display in CAPS

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

Niek Otten

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

All times are GMT +1. The time now is 03:03 AM.