Excel problem, I need a function that returns the name of a month...?

Question

What function will return "Mar" if I enter 3, "Dec" if I enter 12 etc.?

Answer 1

1) Right click on the cell.
2) Select Format Cells..
3) Select Number Tab (should be automatically selected)
4) Select Date from Category list
5) Select your preferred type on the list to the right, in this case the bottom one

If it's just the month you want

Follow steps 1-3 then:

4) Select Custom from Category List
5) Type in 'mmm' in the textbox, which probably says 'general'. (The more letter ms there are the more letters of the month it'll show)

Hope that helps!

Answer 2

You could use a heap of nested if statements i.e if your going to be typing a number 1 to 12 in cell a1 then

if(a1=1,"January",if(a1=2,"February etc

an if statements reads as if ( condition , true so do this, false so do this)

but that becomes messy so the best way is to use a vlookup table
in one column (d1:d12)or somewhere have 1 down to 12 in the column next to it have January February etc

in the cell(say a1) you will enter a number 1-12 and you want the month to show in cell b2 put this formulae into b1
vlookup(a1,d1:d12,1)
and it will vertically lookup in the range d1:d12 for your entered number and then place the contents 1 column over

Answer 3

You need to go to format - cells - date - then choose what you want it will only do
january 06
or january 07 etc if you put no year in it will put january 00 but that is all you can do is month plus date.
Or maybe you could use the replacing tool where you replace certain things ie 1 or 2 with jan and feb

Answer 4

Instead of a function would a drop-down list work better here? I am not certain that there is a function that will do that at the level your looking for. you can try and IF / THAN statement but this will only return one value and not look for multiple. To create a drop down list insert a blank column or go to a column outside of your document space and type in Jan, Feb, etc.; one per cell per row going down. Now go back to the cell that want to select the month for. and click on the cell. now go to the data menu, select "Validation..." Under the tab setting find the drop down box "Allow:" and select list. Now on this tab a new field should be there called "Source". click on the button to the right of this field. This will reduce the box to a small box over your current page find the column that has your months that you just created and click and drag over them to highlight them all. In the Data Validation box you should see the range for the cells that you have just selected. Click on the button to the right of this to return to the menu. Now back on this menu click "OK" at the bottom. You should now be able to have a hidden drop down menu of your months in the cell that you selected. Just click on the cell to see the drop down arrow. To duplicate this menu into other cells just do a right click on the cell with the drop down menu and select copy, then select the cell or cells that you want paste this into and press enter. And there you have it. Not quite you asked for but another way to get at it.

Answer 5

you can use the LOOKUP function. this will allow you to specify exactly what you want. example>>>

1. in column A cells 1-12 put numbers 1 through to 12
2. in column B cells 1-12 put months how you want them displayed.
3. column c cell 1, enter the number of month you want
4. column d, enter the following formula >

=LOOKUP(C1,A1:A12,B1:B12)


As you can see, you can put any text that suits you. Handy for a lot more than just dates, but does what you need.

You can go further to "validate" cell C1 to restrict input to values from 1 to 12

Answer 6

reverse phone number search compiles hundreds of millions of phone book records to help locate the owner's name, location, time zone, email and other public information.

Use a reverse phone lookup to:
Get the identity of an unknown caller.
Identify an area code.
Recall the name of a person whose number you wrote down.
Identify an unfamiliar phone number that shows up on your bill.
https://tr.im/721a7

Answer 7

IF function should do it