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