View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default converting numbers to months

One way (assuming that A1 contains the number):
=CHOOSE(A1,"January","February")

Complete the formula up to December.

Joerg



"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december