Changing the Format of a Date
I have 2007 and can't replicate your problem. Are you sure you followed
Gary's instructions?
-- Right click on the cell, choose Format Cells...
-- On the Number tab, choose Custom
-- In the Type: box, enter mmmm
-- Click OK
You should now see March in the cell
Regards,
Fred.
"Liz J" wrote in message
...
Thanks, Gary. I have 2007 software, and, when I put it in that format, it
just shows the first letter of the month. And, there is another format
that
shows month and year (example: "March-08"), but, the data I'm analyzing is
all for 2008. (The year input is not necessary). Is there a way where I
can
get the month without the year; just the month's name in the cell?
Thank you again!
"Gary''s Student" wrote:
In B2 enter:
=A2 and format as Custom mmmm
--
Gary''s Student - gsnu200816
|