Re: [users] Calc -- monthname() function

2008-02-16 Thread Brian Barker
At 17:24 16/02/2008 -0500, Kenn Goutal wrote: It appears that, in my version at least, there is no function that, given a number 1..12, returns the name of the corresponding month. Try =TEXT(A1*30;). Failing to find one, I tried to fetch the i-th element of an 12-row column of month

Re: [users] Calc -- monthname() function

2008-02-16 Thread TomW
Kenn Goutal wrote: It appears that, in my version at least, there is no function that, given a number 1..12, returns the name of the corresponding month. Am I missing something? Failing to find one, I tried to fetch the i-th element of an 12-row column of month names, but I'm apparently not

Re: [users] Calc -- monthname() function

2008-02-16 Thread Harold Fuchs
On 16/02/2008 22:56, Brian Barker wrote: At 17:24 16/02/2008 -0500, Kenn Goutal wrote: It appears that, in my version at least, there is no function that, given a number 1..12, returns the name of the corresponding month. Try =TEXT(A1*30;). Please, why the *30? It works, but why? --

Re: [users] Calc -- monthname() function

2008-02-16 Thread Harold Fuchs
On 16/02/2008 22:56, Brian Barker wrote: At 17:24 16/02/2008 -0500, Kenn Goutal wrote: It appears that, in my version at least, there is no function that, given a number 1..12, returns the name of the corresponding month. Try =TEXT(A1*30;). Please, why the *30? It works, but why? --

Re: [users] Calc -- monthname() function

2008-02-16 Thread Brian Barker
At 00:07 17/02/2008 +, Harold Fuchs wrote: On 16/02/2008 22:56, Brian Barker wrote: At 17:24 16/02/2008 -0500, Kenn Goutal wrote: It appears that, in my version at least, there is no function that, given a number 1..12, returns the name of the corresponding month. Try =TEXT(A1*30;).

Re: [users] Calc -- monthname() function

2008-02-16 Thread Harold Fuchs
On 17/02/2008 01:10, Brian Barker wrote: At 00:07 17/02/2008 +, Harold Fuchs wrote: On 16/02/2008 22:56, Brian Barker wrote: At 17:24 16/02/2008 -0500, Kenn Goutal wrote: It appears that, in my version at least, there is no function that, given a number 1..12, returns the name of the