# convert a number to month

3

#### 3Suk

dear all,
how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?
I know use vlookup in another table will work, but I prefer a direct formula.

Patrick.

C

#### Claus Busch

hi Patrick,

Am Tue, 15 Jan 2013 00:14:40 -0800 (PST) schrieb 3Suk:
how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?
I know use vlookup in another table will work, but I prefer a direct formula.

try:
=TEXT(DATE(1,A1,1),"MMMM")

Regards
Claus Busch

3

#### 3Suk

dear all,

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?

I know use vlookup in another table will work, but I prefer a direct formula.

Patrick.

Claus,
It works. how about vice versa, a month to a number?

Thanks,
PL.

C

#### Claus Busch

Hi,

Am Tue, 15 Jan 2013 23:11:17 -0800 (PST) schrieb 3Suk:
It works. how about vice versa, a month to a number?

the month name in A1 then:
=MATCH(A1,TEXT(ROW(1:12)*28,"MMMM"),0
and enter the formula with CTRL+Shift+Enter (Array formula)

Regards
Claus Busch

3

#### 3Suk

dear all,

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?

I know use vlookup in another table will work, but I prefer a direct formula.

Patrick.

it returns #VALUE!.
moreover, how to enter with "ALT+shift+enter" and why has to do it?

Thanks
Patrick

C

#### Claus Busch

Hi Patrick,

Am Tue, 15 Jan 2013 23:55:44 -0800 (PST) schrieb 3Suk:
it returns #VALUE!.
moreover, how to enter with "ALT+shift+enter" and why has to do it?

the formula is an array formula. You have to enter it with
CTRL+Shift+Enter and then the formula gets the curled parenthis.
if you don't finish with CTRL+Shift+Enter you get #Value

Regards
Claus Busch

3

#### 3Suk

dear all,

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?

I know use vlookup in another table will work, but I prefer a direct formula.