View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default converting numbers to months

There are many ways

1. If you have numbers in Col A starting at A1
enter this in B1
=Date(1,A1,1)
and format the column as
Custom|mmmm

This will show January, ... depending upon the number in A1

Or you can have
=LOOKUP(A1,{1,2,...12},{"January","February",..."" December"})

Fill the missing numbers, months

or
you can use VLOOLKUP
=VLOOKUP(A1,Sheet2!A:B,2,False)

if you have numbers in Col A and month names in Col B of Sheet2

or...

"theE" wrote:

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