Extract the month name from a month
Hi,
With numbers (1 - 12) in column A us this and drag down
=DATE(2010,A1,1)
Format these cells with a custom format of mmm
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"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
|