I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which will
result in months, that is, March, April, June, July, August, October,
December. What should be specified? Thanks

Not possible using formats, you would need a formula like

=INDEX({"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))


but it is not possible to format a cell with 10 to return October


--
Regards,

Peo Sjoblom



"dindigul" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which will
>result in months, that is, March, April, June, July, August, October,
>December. What should be specified? Thanks
>

Just another way:

=CHOOSE(A1,"January","February","March","April","May","June","July","August","September","October","November","December")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Not possible using formats, you would need a formula like
>
> =INDEX({"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))
>
>
> but it is not possible to format a cell with 10 to return October
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "dindigul" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which will
>>result in months, that is, March, April, June, July, August, October,
>>December. What should be specified? Thanks
>>
>
>

Shorter but alas volatile <bg>


--
Regards,

Peo Sjoblom



"Ragdyer" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Just another way:
>
> =CHOOSE(A1,"January","February","March","April","May","June","July","August","September","October","November","December")
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Not possible using formats, you would need a formula like
>>
>> =INDEX({"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))
>>
>>
>> but it is not possible to format a cell with 10 to return October
>>
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "dindigul" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which will
>>>result in months, that is, March, April, June, July, August, October,
>>>December. What should be specified? Thanks
>>>
>>
>>
>
>

I don't believe it is Peo!

Doesn't generate a <Save> request when opening and closing.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Shorter but alas volatile <bg>
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "Ragdyer" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Just another way:
>>
>> =CHOOSE(A1,"January","February","March","April","May","June","July","August","September","October","November","December")
>>
>> --
>> HTH,
>>
>> RD
>>
>> ---------------------------------------------------------------------------
>> Please keep all correspondence within the NewsGroup, so all may benefit !
>> ---------------------------------------------------------------------------
>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Not possible using formats, you would need a formula like
>>>
>>> =INDEX({"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))
>>>
>>>
>>> but it is not possible to format a cell with 10 to return October
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Peo Sjoblom
>>>
>>>
>>>
>>> "dindigul" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>>I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which will
>>>>result in months, that is, March, April, June, July, August, October,
>>>>December. What should be specified? Thanks
>>>>
>>>
>>>
>>
>>
>
>

This is the latest list.......pre 2007..........of Volatile Functions.

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()


Gord

On Tue, 12 Jun 2007 12:27:54 -0700, "Ragdyer" <(E-Mail Removed)> wrote:

>I don't believe it is Peo!
>
>Doesn't generate a <Save> request when opening and closing.

You are correct, wonder where I got that from?

Peo


"Ragdyer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I don't believe it is Peo!
>
> Doesn't generate a <Save> request when opening and closing.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Shorter but alas volatile <bg>
>>
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "Ragdyer" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Just another way:
>>>
>>> =CHOOSE(A1,"January","February","March","April","May","June","July","August","September","October","November","December")
>>>
>>> --
>>> HTH,
>>>
>>> RD
>>>
>>> ---------------------------------------------------------------------------
>>> Please keep all correspondence within the NewsGroup, so all may benefit
>>> !
>>> ---------------------------------------------------------------------------
>>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Not possible using formats, you would need a formula like
>>>>
>>>> =INDEX({"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))
>>>>
>>>>
>>>> but it is not possible to format a cell with 10 to return October
>>>>
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Peo Sjoblom
>>>>
>>>>
>>>>
>>>> "dindigul" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>>I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which
>>>>>will result in months, that is, March, April, June, July, August,
>>>>>October, December. What should be specified? Thanks
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

In XL2k Gord, Areas() is *off* the list ... AND ... INFO() is included.

This is what I have ... don't remember from where/who it came from:

OLD NEW
1 Areas
2 Index
3 Offset Offset
4 Cell Cell
5 Indirect Indirect
6 Rows
7 Columns
8 Now Now
9 Today Today
10 Rand Rand
11 Info

Would be nice if someone would/could verify this list!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> This is the latest list.......pre 2007..........of Volatile Functions.
>
> AREAS()
> OFFSET()
> CELL()
> INDIRECT()
> NOW()
> TODAY()
> RAND()
>
>
> Gord
>
> On Tue, 12 Jun 2007 12:27:54 -0700, "Ragdyer" <(E-Mail Removed)>
> wrote:
>
>>I don't believe it is Peo!
>>
>>Doesn't generate a <Save> request when opening and closing.
>

Since you're just a young kid, you can't use that "old age" excuse that Gord
and I use so often.<bg>

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You are correct, wonder where I got that from?
>
> Peo
>
>
> "Ragdyer" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I don't believe it is Peo!
>>
>> Doesn't generate a <Save> request when opening and closing.
>> --
>> Regards,
>>
>> RD
>>
>> ---------------------------------------------------------------------------
>> Please keep all correspondence within the NewsGroup, so all may benefit !
>> ---------------------------------------------------------------------------
>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Shorter but alas volatile <bg>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Peo Sjoblom
>>>
>>>
>>>
>>> "Ragdyer" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Just another way:
>>>>
>>>> =CHOOSE(A1,"January","February","March","April","May","June","July","August","September","October","November","December")
>>>>
>>>> --
>>>> HTH,
>>>>
>>>> RD
>>>>
>>>> ---------------------------------------------------------------------------
>>>> Please keep all correspondence within the NewsGroup, so all may benefit
>>>> !
>>>> ---------------------------------------------------------------------------
>>>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> Not possible using formats, you would need a formula like
>>>>>
>>>>> =INDEX({"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))
>>>>>
>>>>>
>>>>> but it is not possible to format a cell with 10 to return October
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>>
>>>>> Peo Sjoblom
>>>>>
>>>>>
>>>>>
>>>>> "dindigul" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>>I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which
>>>>>>will result in months, that is, March, April, June, July, August,
>>>>>>October, December. What should be specified? Thanks
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Hi Rick

Your new list is applicable to XL2002, 2003 and 2007

--
Regards

Roger Govier


"Ragdyer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In XL2k Gord, Areas() is *off* the list ... AND ... INFO() is
> included.
>
> This is what I have ... don't remember from where/who it came from:
>
> OLD NEW
> 1 Areas
> 2 Index
> 3 Offset Offset
> 4 Cell Cell
> 5 Indirect Indirect
> 6 Rows
> 7 Columns
> 8 Now Now
> 9 Today Today
> 10 Rand Rand
> 11 Info
>
> Would be nice if someone would/could verify this list!
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may
> benefit !
> ---------------------------------------------------------------------------
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:(E-Mail Removed)...
>> This is the latest list.......pre 2007..........of Volatile
>> Functions.
>>
>> AREAS()
>> OFFSET()
>> CELL()
>> INDIRECT()
>> NOW()
>> TODAY()
>> RAND()
>>
>>
>> Gord
>>
>> On Tue, 12 Jun 2007 12:27:54 -0700, "Ragdyer" <(E-Mail Removed)>
>> wrote:
>>
>>>I don't believe it is Peo!
>>>
>>>Doesn't generate a <Save> request when opening and closing.
>>
>
>