| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the month name from a month
Hi there,
I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
Hi,
With numbers (1 - 12) in column A us this and drag down =DATE(2010,A1,1) Format these cells with a custom format of mmm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Grd" wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
You could use the month column in the DATE function and then use the
TEXT function to extract just the 3 letter month as in: =TEXT(DATE(0,A1,1),"mmm") On Feb 3, 2:45*pm, Grd wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
If there is just a number in a single cell, just format it to look
like a month name. In Excel 2003, select the cell, press Ctrl+1, go to Number tab, click "Custom" and in the Type box, enter "mmm" (without quotes). --JP On Feb 3, 2:45*pm, Grd wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
=TEXT(A1&"-10","mmm")
"Grd" wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
Another one...
A1 = a number from 1 to 12 =TEXT(A1*29,"mmm") -- Biff Microsoft Excel MVP "Grd" wrote in message ... Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
This method works for me.
Tx "Mike H" wrote: Hi, With numbers (1 - 12) in column A us this and drag down =DATE(2010,A1,1) Format these cells with a custom format of mmm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Grd" wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
Hi,
I had to add "-2010" instead of just "-10" but that worked. =TEXT(A1&"-2010","mmm") tx Grd "Teethless mama" wrote: =TEXT(A1&"-10","mmm") "Grd" wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
Works too!
Tx Grd "T. Valko" wrote: Another one... A1 = a number from 1 to 12 =TEXT(A1*29,"mmm") -- Biff Microsoft Excel MVP "Grd" wrote in message ... Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd . |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
Thanks for the reply,
They all come out Jan. But the Ctrl+1 shortcut was great. Tx Grd "JP" wrote: If there is just a number in a single cell, just format it to look like a month name. In Excel 2003, select the cell, press Ctrl+1, go to Number tab, click "Custom" and in the Type box, enter "mmm" (without quotes). --JP On Feb 3, 2:45 pm, Grd wrote: Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd . |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
My bad. But it looks like others came in with the correct answer.
--JP On Feb 3, 10:49*pm, Grd wrote: Thanks for the reply, They all come out Jan. But the Ctrl+1 shortcut was great. Tx Grd |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the month name from a month
You're welcome!
-- Biff Microsoft Excel MVP "Grd" wrote in message ... Works too! Tx Grd "T. Valko" wrote: Another one... A1 = a number from 1 to 12 =TEXT(A1*29,"mmm") -- Biff Microsoft Excel MVP "Grd" wrote in message ... Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract the month | Excel Discussion (Misc queries) | |||
| Extract month from date | Excel Discussion (Misc queries) | |||
| Extract Month | Excel Discussion (Misc queries) | |||
| How do I extract just the month | Excel Worksheet Functions | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
Linear Mode
