Convert mm/dd/yyyy to mm/yy in excel 2007

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
How do I convert mm/dd/yyyy to mm/yy in excel 2007?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use format of mm/yy

right click on the cell
choose cell format
choose custom and type in mm/yy