Can't format date to MM/DD/YY

gogreen · #1 10-31-2016, 02:02 PM

I find it preposterous that I can't set a date format of MM/DD/YY as an type option. I must be doing something wrong. To get what I want, I'm formatting the date cells as text. Seems a bit ridiculous to me. So what am I missing? Thanks.

gebobs · #2 10-31-2016, 03:08 PM

Have you tried using the canned format Short Date?

gogreen · #3 10-31-2016, 03:24 PM

Quote:

Have you tried using the canned format Short Date?

Aha! I knew there was something I missed! Easy when you know how. Thanks, gebobs.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date format	Welda Tait	Outlook	2	05-13-2016 01:26 AM
Date format but with Jan Feb mar etc how is this done ?	DBenz	Excel	3	12-21-2014 05:00 AM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM
MS Query date format	remigio	Word	3	08-21-2012 10:54 PM
date format	gsrikanth	Excel	1	12-28-2011 05:06 AM