Hello Kimber, You need to use the English UK option in the Locale combo box found in the format cells dialog box. When you change the Locale to English UK you can then find the date format you are wanting in the Type list box. You should select the column or range of cells first. Otherwise, you will need to either change it each time through the dialog box or by using paste special to apply the format.
Take care. Brian Lee [email protected] -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Kimber Gardner Sent: Friday, June 17, 2016 5:05 AM To: jaws-users-list <[email protected]> Subject: [JAWS-Users] Custom formatting a date in excel 2010 Hi All, I need to enter a date in an excel spreadsheet in the following format: yyyy-mm-dd. But each time I try to enter it that way, excel reformats it like this, mm/dd/yyyy. I need the info formatted just as I described even down to dashes instead of slashes, but there is no such formatting choice in the reformat cells dialog box. Is there some method for imposing custom formatting in a specific column of a spread sheet? I am using excel 2010 if that makes any difference. Thanks for any help. Kimber -- Kimberly For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
