MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Fill Dates in ALL CAPS

April 27, 2017 - by Bill Jelen

Fill Dates in ALL CAPS

Excel can the fill handle fill dates in ALL CAPS?

Watch Video

  • Steve wants to fill dates in ALL CAPS
  • Choice 1: Felix Titling font
  • Choice 2: Formula using UPPER and TEXT: =UPPER(TEXT(C2,"DDDD, MMMM D, YYYY"))

Video Transcript

Learn Excel from MrExcel Podcast, Episode 2085: Fill Dates in All Caps

Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.  Today's question from Steve in Indianapolis: Is there a way to fill dates in ALL CAPS?  I just shown how to use the Fill Handle to take this date and drag it down.  But hey wait!  I need that to be in ALL CAPS; and well, that's going to be tough. 

First thing, I thought as well, what if we went in to the Custom Number Format which is all lowercase, and if we converted it to – 1 2 3 - uppercase like that, would that somehow do the right thing?  But no, no.  Of course that doesn't work at all.   It still comes in - alright there you can see it's in lowercase.  Alright, so yeah, cheap, cheap, Trick Number 1: select the Date, come here to the Font dropdown and what we're looking for is a font that is in ALL CAPS.  Algerian is one, Felix Titling is another.  Figure out which one it is, and see even lowercase, lowercase is shown as uppercase like that.  Or - but hey, let's face it.  Algerian and Felix Titling one are weird fonts.  If you wanted to use your own font, alright, so here's today's date.  Put that in by the way with the Ctrl+;  I’m recording it as a couple of days ahead.  Grab the Fill Handle and drag.  And then over here we’re going to use this formula: =UPPER of the TEXT.  The TEXT to C2, and this is where we put our Custom Number Format: lowercase, uppercase doesn't matter because we're going to send it into the UPPER function like that.  Double-click to copy it down and now you can use whatever crazy font you want or normal font or whatever you need.

Alright, these tips and a lot more tips like it are in my book, Power Excel with MrExcel, the 2017 Edition.  Click that “i” on the top-right hand corner to buy the book. 

Steve wants to do fill dates in ALL CAPS.  Choice 1: any kind of a font, it is all caps like Felix Titling or Algerian or, Choice 2: we used a formula using UPPER and TEXT.

Well, thanks to you for that question.  I want to thank you for stopping by.  We’ll see you next time for another netcast from MrExcel. 

It's not a date, that's a fake.

Download File

Download the sample file here: Podcast2085.xlsm

Title Photo: UweTuchen / Pixabay

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.