A
Anitha
I want to convert number to corresponding month eg., 1 Jan and so on
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi Anitha
One way, with your number in A1, enter in B1
=DATE(1,A1,1)
and format cell B1 as Format>Cells>Custom> mmm
Date takes Date(Year,Month,Day) but we are not interested in the day or
year, hence 1 will suffice in each case.
The result will be 01 Jan 1901, but the format will cause it to show as
just Jan.
One way, with your number in A1, enter in B1
=DATE(1,A1,1)
and format cell B1 as Format>Cells>Custom> mmm
Date takes Date(Year,Month,Day) but we are not interested in the day or
year, hence 1 will suffice in each case.
The result will be 01 Jan 1901, but the format will cause it to show as
just Jan.
D
David Biddulph
=DATE(2006,A1,1) and custom Format as mmmm
R
Roger Govier
The result will be 01 Jan 1901, but the format will cause it to show
That should have been if A1 contains 1
If A1 contains 10, then it would be 01 Oct 1901 and will show Oct.
as just Jan
That should have been if A1 contains 1
If A1 contains 10, then it would be 01 Oct 1901 and will show Oct.
S
Stefi
The number to be converted being in A1
=TEXT(DATE(1900,A1,1),"mmmm")
Regards,
Stefi
„Anitha†ezt Ãrta:
=TEXT(DATE(1900,A1,1),"mmmm")
Regards,
Stefi
„Anitha†ezt Ãrta: