You're welcome!

--
Biff
Microsoft Excel MVP


"Grd" wrote in message
...
Works too!

Tx
Grd

"T. Valko" wrote:

Another one...

A1 = a number from 1 to 12

=TEXT(A1*29,"mmm")

--
Biff
Microsoft Excel MVP


"Grd" wrote in message
...
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


.