Prev: Formula for adding a cell in multiple workbooks
Next: count cells in a table that meet multiple criteria
From: JP on 4 Feb 2010 10:02
My bad. But it looks like others came in with the correct answer.
On Feb 3, 10:49 pm, Grd <G...(a)discussions.microsoft.com> wrote:
> Thanks for the reply,
> They all come out Jan. But the Ctrl+1 shortcut was great.
From: T. Valko on 4 Feb 2010 11:45
Microsoft Excel MVP
"Grd" <Grd(a)discussions.microsoft.com> wrote in message
> Works too!
> "T. Valko" wrote:
>> Another one...
>> A1 = a number from 1 to 12
>> Microsoft Excel MVP
>> "Grd" <Grd(a)discussions.microsoft.com> 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