Dates - Display in CAPS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Not with formatting, but with a formula like

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allways Display in Caps Letter 1
Change all text on Spread sheet 1
auto correct small leters to caps letters 4
Format date month as all CAPs 20FEB07 4
Transforming many cells of all caps into first letter capitals onl 5
ACRONYM OF CAPS ONLY 3
How do I convert addresses to all caps in Office 2007? 3
How do I get First-Letter cap in a cell? 2

Back
Top