View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grd Grd is offline
external usenet poster
 
Posts: 118
Default Extract the month name from a month

Hi there,

I have a month column with just a number like 1 , 7 etc. I'd like to see Jan
instead of 1 and Jul instead of 7. Is there a formula for function for this.
There is only one number in a column at one time.

Any help would be greatly appreciated.

Tx

Grd