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
|