On Wed, 15 Nov 2006 18:11:02 -0800, Graham
wrote:

I have a master sheet in which date is stored in columns by month. Row 1 has
the year and row 2 has the month number (1 to 12).

There are presentation sheets that reference subsets of the master data and
on those sheets I would like to display a 3 char string for the month e.g.
'JAN' for month 1.

Any suggestions, please?


=TEXT(DATE(2006,A2,1),"mmm")

(The year and day of the month are irrelevant for this purpose).


--ron