Show a month as Aug, Sep etc
 

With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)
--
tia

Jock

Show a month as Aug, Sep etc
 

Try,

Format cell with custom format of "mmm"
No quotes

Mike

"Jock" wrote:

With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)
--
tia

Jock

Show a month as Aug, Sep etc
 

Here are a couple options....

Since you already have a Date in A1

C1: =A1
Set the custom number format of B1 to "mmm".
<format<cells<number tab
Category: Custom
Type: mmm..........Click [OK]

or, if you want actual text:
C1: =TEXT(A1,"mmm")

A less elegant alternative if you REALLY want to use the value of cell B1 is:
C1: =TEXT(B1&"/2007","mmm")

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Jock" wrote:

With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)
--
tia

Jock

Show a month as Aug, Sep etc
 

Jock,

If you really want the brackets the custom format is
(mmm)

Mike

"Jock" wrote:

With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)
--
tia

Jock

Show a month as Aug, Sep etc
 

On Thu, 9 Aug 2007 04:32:02 -0700, Jock wrote:

With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)


C1: =A1
Format (format/cells/number/custom type: ) as mmm or, if you want it to show
with the parentheses, as "(mmm)" without the quotes.

If you really want it to be Text, then use this formula:

=TEXT(A1,"mmm") or
=TEXT(A1,"(mmm)")

Note that for the purposes of the above, the contents of B1 is irrelevant.

If you really want to convert the number in B1 to text, as you wrote, rather
than use the original source, then use the CHOOSE function:

=CHOOSE(B1,"Jan","Feb","Mar", ...)

--ron

Show a month as Aug, Sep etc
 

Many thanks to Mike, Ron C and Ron S.
Job done.
:D


Jock


"Ron Rosenfeld" wrote:

On Thu, 9 Aug 2007 04:32:02 -0700, Jock wrote:

With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)


C1: =A1
Format (format/cells/number/custom type: ) as mmm or, if you want it to show
with the parentheses, as "(mmm)" without the quotes.

If you really want it to be Text, then use this formula:

=TEXT(A1,"mmm") or
=TEXT(A1,"(mmm)")

Note that for the purposes of the above, the contents of B1 is irrelevant.

If you really want to convert the number in B1 to text, as you wrote, rather
than use the original source, then use the CHOOSE function:

=CHOOSE(B1,"Jan","Feb","Mar", ...)

--ron