Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How can I enter dates in an Excel spreadsheet so that they appear in the form 00-00-0000?
I am using Excel 2008 for Macintosh. The program converts them to the form 00/00/00. If the dates are old enough, the program will leave them in the 00/00/0000 form. That would be close enough. If, however, there is a mixture of more recent dates and 19th century dates, then some are in the 00/00/0000 form while others are in the 00/00/00 form. 12/31/1920 and 12/31/2020 appear as the same date.
1 Answer
- ScrawnyLv 710 years agoFavorite Answer
Select the cells with the dates right click and click on Format Cells. Choose Date, Custom and enter mm-dd-yyyy click OK. That is how it is done with Excel on the PC and it probably is quite similar to that on the Mac.
Source(s): Experience