Show a month as Aug, Sep etc

[Guest]

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)

 

[Guest]

Try,

Format cell with custom format of "mmm"
No quotes

Mike

 

[Guest]

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

 

[Guest]

Jock,

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

Mike

 

[Ron Rosenfeld]

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

 

[Guest]

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



Jock