=Text(n,"mmm") always returns "Jan" when n=1..12
n has to be a complete date value (yeae, month, day).
Try
=Text(date(2009,n,1),"mmm")
Regards,
Stefi
€žBlaze-Of-Glory€ť ezt Ă*rta:
Excel 2007 - Why doesn't this work? Being forced to use VLookup and make a
month table each time I want to convert a month number to a month nme
|