I want to enter a date in a cell as mm/yy where the slash "/" always populates automatically. How do I do this? The problems I'm facing are:
1) if I choose 00/00 or ##/## in Custom it converts my date into another fraction or decimal.
2) there's no option for a "mm/yy" under Date
3) the cell is currently a Text, which also has no customization option (ie., when entering the date you have to manually type "/").
Thanks so much!
Bookmarks