Month Day formating

[RodneyW]

I want to format cells in one row so that it shows the date this way

May 5 versus 5-May

None of the options in "Format Cells" either in "Date" or in "Custom" give me the option for Month/Day

Any ideas?

Thanks

 

[Jonmo1]

Use a custom format of

"mmm d" - without the quotes

 

[Rick Rothstein]

Use a custom format of

"mmm d" - without the quotes

May was a bad example month for the OP to use as it is only a 3-letter long month, so it is hard to know if the OP is looking for abbreviated months (like your formatting suggestion yields) or full month names. If the OP wants full month names, then he should use 4 m's instead...

"mmmm d" - without the quote marks

 

[RodneyW]

It worked fine with the mmm since I really only wanted the first three characters anyway.

This was a great learning experience because I also learned that custom code could be entered. I always thought I had to pick from one of the given options.

THANKS!