If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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 . |
|
Thread Tools | |
Display Modes | |
|
|