make number to month name

[#1]

Hi,

does anyone now if I can create out of a number a month name??

example:

8 -> Aug

9 -> Sep

please help me

regards,

MT

[#2]

Thank you Jonathan.  This works seems to work perfectly and simplest without need to use ApplyMaps or any loops.  Would mark as correct!

[iskezhanov]

date(MakeDate(2000, Your_Month_Number_field,1),'MMMM')

[mehranbi]

Try this:

=Month( MakeDate(1, YourMonthNumber, 1) )