View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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