ExcelBanter - I need date format to be set up as month/year.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - I need date format to be set up as month/year. (https://www.excelbanter.com/new-users-excel/61230-i-need-date-format-set-up-month-year.html)

Aaron

I need date format to be set up as month/year.

I need date format to be set up as month/year ie 05/10 for may 2010. I have
tried everything and cant seem to figure this one out?

bpeltzer

I need date format to be set up as month/year.

Format cells. On the number tab, select the custom category, and enter mm/yy
in the textbox.
HTH. --Bruce

"Aaron" wrote:

I need date format to be set up as month/year ie 05/10 for may 2010. I have
tried everything and cant seem to figure this one out?

Aaron

I need date format to be set up as month/year.

Thats worked - Thanks for that.

"bpeltzer" wrote:

Format cells. On the number tab, select the custom category, and enter mm/yy
in the textbox.
HTH. --Bruce

"Aaron" wrote:

I need date format to be set up as month/year ie 05/10 for may 2010. I have
tried everything and cant seem to figure this one out?

All times are GMT +1. The time now is 03:13 AM.