From: Grd on 3 Feb 2010 14:45 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 From: Mike H on 3 Feb 2010 14:51 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 From: Mark on 3 Feb 2010 15:08 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 From: JP on 3 Feb 2010 15:11 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 From: Teethless mama on 3 Feb 2010 15:38 =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