Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

The dates are showing up in my Excel sheet as m/d/yyyy or mm/d/yyyy even though the format is set as mm/dd/yyyy. How can I get the dates to show up as mm/dd/yyyy?

April 26, 2017dates Excel format mm Sheet yyyy

0

Posted

The dates are showing up in my Excel sheet as m/d/yyyy or mm/d/yyyy even though the format is set as mm/dd/yyyy. How can I get the dates to show up as mm/dd/yyyy?

1 Answer

0

Posted

Highlight all dates and go to Format > Cells. Choose mm/dd/yyyy. Go to File > Save As and choose .csv. Close Excel and go to the folder or location where you saved the .csv file. Open it back up in Excel and go to File > Save As and this time save it as an Excel file and rename it so that you can tell it apart from the original. Close Excel then go to the location where you saved the new Excel file and re-open it. It should now appear with the correct date format and you should be able to re-import it into Fringe Facts without a problem.