Show a month as Aug, Sep etc

J

Jock

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)
 
R

Ron Coderre

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
 
R

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)
Click to expand...


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
 
Top