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.

Scrawny2011-08-27T16:28:38Z

Favorite 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.

01

Related Questions

YAHOO! MAIL start: 0000-00-00 end: 0000-00-00?How can you put 00 or 01 into a cell on an excel spreadsheet?DD Form 214 Reserve obligation term date 00/00/0000?can't we think of changing the date to 01/00/0000?Is this true?did i really win £1.5,0000.000,00 or it's just a hoax?

Trending Questions

Which software is best for editing? ?19 answersDid you like being on lockdown during covid?15 answersWhich one is better? Office 2019 or Office 365?13 answersI saw Windows Vista on computer behind desk at  cinema?7 answersCovid 19 face mask?4 answers