i have got 100 dates entered in 100 cells.
eg.
01/02/2006
03/03/2006
04/05/2006
08/09/2006
and i have formatted these cells as date.
now in the next column, i want month name of that date
i.e. january,february etc.
how to do that
if i use month function i get only month number i.e. 1 for jan but i want full name of the month.
can anybody help ?
2007-01-29 17:33:49 · 8 answers · asked by lakshmi r 4 in Computers & Internet ➔ Software
Go to format cells, number, custom, type: put in mmmm, then click ok.
2007-01-29 17:44:45 · answer #1 · answered by T esira 4 · 1⤊ 1⤋
Type January in the next column. Take the cursor to the right-bottom of the cell till the plus sign changes to black. Press the left click of the mouse and drag onto the other cells. February, March etc. will be displayed automatically. Just release the mouse when u complete the 100 cells. Try this. Best of luck
2007-01-30 02:30:52 · answer #2 · answered by as n 2 · 0⤊ 2⤋
You can just copy all of the info to the other column then just fornat it to show the month it will change it from 1/02/06 to january 06
2007-01-30 01:49:47 · answer #3 · answered by Anonymous · 1⤊ 1⤋
In the cell Adjacent to the cell in which you have typed the date
type the below function
=TEXT(A2,"MMMM")
Replace A2 with the Number of the cell in which you have typed the date.
Drag the same formula for all the 100 cells.
I have tested it and it worked.
If you need any further clarifications please get back to me.
2007-01-30 03:44:23 · answer #4 · answered by Sunil Saripalli 5 · 1⤊ 1⤋
Just type in the word. If that doesn't work, change the formatting to "text"
2007-01-30 01:57:41 · answer #5 · answered by tiffany 6 · 0⤊ 1⤋
just type in the name of the month in the column
2007-01-30 01:38:34 · answer #6 · answered by the man the myth the answerer 5 · 1⤊ 1⤋
Click on the cell where you want. Enter this formula in the formula bar =IF(MONTH(A1)=1,"January",IF(MONTH(A1)=2,"Feberuary",IF(MONTH(A1)=3,"March",IF(MONTH(A1)=4,"April",IF(MONTH(A1)=5,"May",IF(MONTH(A1)=6,"June",IF(MONTH(A1)=7,"July",IF(MONTH(A1)=8,"August",IF(MONTH(A1)=9,"September",IF(MONTH(A1)=10,"October",IF(MONTH(A1)=11,"November",IF(MONTH(A1)=12,"December")))))))))))). Now press "Enter Key".
Then point mouse to the right bottom corner of the cell(small black square). The mouse pointer will turn into a black "Plus" or cross. Now drag down to cover all 100 cells in this column.
Voila! Its done.
2007-01-30 02:10:53 · answer #7 · answered by Mickey 1 · 0⤊ 2⤋
give me your email coz i made one and i will send it to you...
coz, the cells reference is hard to discuss here...
2007-01-30 01:47:48 · answer #8 · answered by aRnObIe 4 · 0⤊ 2⤋