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.

--JP

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.
>
> Tx
> Grd
From: T. Valko on 4 Feb 2010 11:45
You're welcome!

--
Biff
Microsoft Excel MVP


"Grd" <Grd(a)discussions.microsoft.com> wrote in message
news:59409D54-8731-4A03-BBAE-C624A1AB8D14(a)microsoft.com...
> 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" <Grd(a)discussions.microsoft.com> wrote in message
>> news:31E393B8-E567-44BA-8898-EAE77F5B116C(a)microsoft.com...
>> > 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
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2 3
Prev: Formula for adding a cell in multiple workbooks
Next: count cells in a table that meet multiple criteria