View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Converting numbers to month names

It is not a "glitch" Here are numbers which, when correctly formatted,
display dates:

Jan 1
Feb 32
Mar 61
Apr 92
May 122
Jun 153
Jul 183
Aug 214
Sep 245
Oct 275
Nov 306
Dec 336

--
Gary''s Student - gsnu200806


"Charles" wrote:

I think I've found a glitch in excel that I would like to manipulate. I have
found that if I put the number "444" in a cell, Excel will convert this to
the month name "March" using customer formatting. When excel looks to the 444
number and I ask for "mmmm" it displays the month name of March. My question
is what number do I use for all twelve months. What number do I use for
September? Where do I find the number codes at?
--
Thanks!!

Charles