Home

HOW TO GET THE NAMES OF MONTHS IN DATES WRITTEN IN CAPITAL LETTERS, BOTH IN ENGLISH AND SPANISH

%3CLINGO-SUB%20id%3D%22lingo-sub-769068%22%20slang%3D%22en-US%22%3EHOW%20TO%20GET%20THE%20NAMES%20OF%20MONTHS%20IN%20DATES%20WRITTEN%20IN%20CAPITAL%20LETTERS%2C%20BOTH%20IN%20ENGLISH%20AND%20SPANISH%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769068%22%20slang%3D%22en-US%22%3E%3CP%3EHOW%20TO%20GET%20THE%20NAMES%20OF%20MONTHS%20IN%20DATES%20WRITTEN%20IN%20CAPITAL%20LETTERS%2C%20BOTH%20IN%20ENGLISH%20AND%20SPANISH%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769086%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%20GET%20THE%20NAMES%20OF%20MONTHS%20IN%20DATES%20WRITTEN%20IN%20CAPITAL%20LETTERS%2C%20BOTH%20IN%20ENGLISH%20AND%20SPANISH%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769086%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380579%22%20target%3D%22_blank%22%3E%40JRHPERU%3C%2FA%3EPlease%20do%20not%20write%20in%20all%20capital%20letters%2C%20it%20is%20harder%20to%20read%20and%20sometimes%20considered%20as%20shouting.%3C%2FP%3E%0A%3CP%3EHave%20a%20look%20at%20the%20attached%20workbook%2C%20it%20contains%20a%20small%20table%20with%20three%20columns.%20The%20first%20are%20just%20fixed%20dates%2C%20the%20second%20and%20thirs%20use%20a%20formula%20to%20display%20the%20names%20of%20the%20months.%20Then%20there%20is%20a%20second%20table%20with%20just%20one%20row%20in%20which%20I%20demonstrate%20how%20to%20use%20the%20data%20of%20the%20first%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769723%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%20GET%20THE%20NAMES%20OF%20MONTHS%20IN%20DATES%20WRITTEN%20IN%20CAPITAL%20LETTERS%2C%20BOTH%20IN%20ENGLISH%20AND%20SPANISH%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769723%22%20slang%3D%22en-US%22%3EIn%20addition%2C%20to%20write%20any%20text%20in%20capital%20letters%20you%20may%20use%20the%20UPPER()%20function.%3C%2FLINGO-BODY%3E
JRHPERU
Occasional Visitor

HOW TO GET THE NAMES OF MONTHS IN DATES WRITTEN IN CAPITAL LETTERS, BOTH IN ENGLISH AND SPANISH

3 Replies

@JRHPERU Please do not write in all capital letters, it is harder to read and sometimes considered as shouting.

Have a look at the attached workbook, it contains a small table with three columns. The first are just fixed dates, the second and thirs use a formula to display the names of the months. Then there is a second table with just one row in which I demonstrate how to use the data of the first table.

In addition, to write any text in capital letters you may use the UPPER() function.

@JRHPERU 

If to show the date using format with capital letter in the same cell in which the date is entered (e.g. some invoices or reports where capital letter format is required) when, to my knowledge, that's only with macro. You may easy google for such samples.

 

If the date and its text representation are in different cells - with formulas as above it'll be easier.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies