Forum Discussion
Solved
Adding a new column as month name
Hi
In this screen shot i highlighted date column, i want to add a new column on right side as "Month name" how can i add months name in my new column as it is defined in date column,
Example 1: 2nd row the date is "06/17/2013" so in my new column it appear as "June"
Example 2: 4th row the date is '10/18/2012" so in my new column it appear as "October".
this data contains more than 7000+ rows
Hi there. I researched it more detailed and I have learned that the shortcuts I am trying to use with ALT key in Windows are called as "Accelerator keys" and it is not available on Mac. There is a site that allows you to use them on Mac even if it doesn't include all features in that site. https://www.acceleratorkeys.com/
However i found another way that allows Mac users to customize shortcuts as you want in the site below. I tried to use ALT+W+F+F for freeze panes to do it same like on Windows but you can only use 1 key after modifier keys. So i will assign a few shortcuts to solve the problem that slows me to use excel.
1 Reply
Depends on goals.
1) You may reference =C2 and apply custom number format mmmm. Still will be a date, but shown as month name. Or you may apply this format to entire column C if concrete date is not needed.
2) If you need it as text, use =TEXT(C2, "mmmm")
