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

Closed
Maria - Apr 13, 2010 at 03:34 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 13, 2010 at 03:37 PM
How do I convert mm/dd/yyyy to mm/yy in excel 2007?

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Apr 13, 2010 at 03:37 PM
You can use format of mm/yy

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