formula request

Column A contains a date, entered as 21/04/05, which is formated to display
as Apr-05. I would like to have Column B display "April" or even "Apr", a
text result. I've tried the MONTH function, but that gives me a number.
Suggestions? Thank you.

Format...
mmmm will show April
mmm will show Apr
HTH,
--
Gary Brown
gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com


"A. Toczko" wrote:

> Column A contains a date, entered as 21/04/05, which is formated to display
> as Apr-05. I would like to have Column B display "April" or even "Apr", a
> text result. I've tried the MONTH function, but that gives me a number.
> Suggestions? Thank you.
>
>
>

=CHOOSE(MONTH(D11),"Jan","Feb","Mar"...

or you could try using Custom in the Number tab under the Format/Cells menu,
then type in:

mmmm

That will give you the name of the month.

Hope that helps and if it does, please vote for this post.

G.Morales

"A. Toczko" wrote:

> Column A contains a date, entered as 21/04/05, which is formated to display
> as Apr-05. I would like to have Column B display "April" or even "Apr", a
> text result. I've tried the MONTH function, but that gives me a number.
> Suggestions? Thank you.
>
>
>

in column B type

=Text(A1,"Mmm")


"A. Toczko" <sandpipr@nbnet.nb.ca> wrote in message
news:%23iM3%23%23mWFHA.2984@tk2msftngp13.phx.gbl...
> Column A contains a date, entered as 21/04/05, which is formated to
> display as Apr-05. I would like to have Column B display "April" or even
> "Apr", a text result. I've tried the MONTH function, but that gives me a
> number. Suggestions? Thank you.
>

Thank you all for your suggestions!

"Duke Carey" <duke_No_Junk_carey_at_hotmail.com> wrote in message
news:eVNiTrnWFHA.1384@TK2MSFTNGP09.phx.gbl...
> in column B type
>
> =Text(A1,"Mmm")
>
>
> "A. Toczko" <sandpipr@nbnet.nb.ca> wrote in message
> news:%23iM3%23%23mWFHA.2984@tk2msftngp13.phx.gbl...
>> Column A contains a date, entered as 21/04/05, which is formated to
>> display as Apr-05. I would like to have Column B display "April" or even
>> "Apr", a text result. I've tried the MONTH function, but that gives me a
>> number. Suggestions? Thank you.
>>
>
>