Extract the month name from a month
You could use the month column in the DATE function and then use the
TEXT function to extract just the 3 letter month as in:
=TEXT(DATE(0,A1,1),"mmm")
On Feb 3, 2:45*pm, Grd wrote:
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
|