G Guest Apr 5, 2007 #1 I'm a novice at Excel. How do I get the date format ddmmmyy to display the month portion in CAPs? Thank you any assistance you can give.
I'm a novice at Excel. How do I get the date format ddmmmyy to display the month portion in CAPs? Thank you any assistance you can give.
F Fred Smith Apr 5, 2007 #2 A common question that's been asked several times. You can't format a date to display all capitals. You can create a text cell, though, which will do it, as in: =upper(text(a1,"ddmmmyy"))
A common question that's been asked several times. You can't format a date to display all capitals. You can create a text cell, though, which will do it, as in: =upper(text(a1,"ddmmmyy"))
T T. Valko Apr 5, 2007 #3 You can't unless you want to use a TEXT string as the date. Manually typed in: '20FEB07 Or, if the true date is already entered in a cell: A1 = 20-Feb-07 (a true Excel DATE) =UPPER(TEXT(A1,"ddmmmyy")) Will return 20FEB07 as a *TEXT* string (not a true Excel DATE) Biff
You can't unless you want to use a TEXT string as the date. Manually typed in: '20FEB07 Or, if the true date is already entered in a cell: A1 = 20-Feb-07 (a true Excel DATE) =UPPER(TEXT(A1,"ddmmmyy")) Will return 20FEB07 as a *TEXT* string (not a true Excel DATE) Biff
G Guest Apr 5, 2007 #4 Thank you Fred Smith and T. Valko very much for such a quick response. It was what I needed.
T T. Valko Apr 5, 2007 #5 You're welcome. Thanks for the feedback! Kind of makes you wonder why you can't format a date in that manner!!!!! Biff
You're welcome. Thanks for the feedback! Kind of makes you wonder why you can't format a date in that manner!!!!! Biff
