Sep 14 2017 10:39 AM
Sep 14 2017 10:39 AM
I'm trying to avoid entering the slashes during data entry. I want the date formated mm/dd/yyyy. Is it possible to simply enter mmddyyyy and have it auto format to the date format above?
Sep 14 2017 06:23 PM
Yes, choose the Format Cells command, select Custom from the Category listbox, and type ##"/"##"/"#### into the Type textbox.