converting numbers to months
'beautiful' solution...
"T. Valko" wrote:
Try this:
A1 = a number from 1 to 12
=TEXT(A1*30,"mmmm")
--
Biff
Microsoft Excel MVP
"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december
|