Excel 2016 for Beginners Part 11: How to Format Dates in an Excel 2016 Spreadsheet



Get my free 3-hour course for Excel 2016 course: https://simonsezit.leadpages.co/free-excel-2016-course/. Get 21 training videos to help you learn MS Excel 2016.

During this Microsoft Excel 2016 training tutorial video, we will show you how to format dates entered on the workbook. You will learn how to change date and time settings according to your region, how to format dates in their short or long forms, how to work with dates that appear invalid in a cell, as well as how Excel…

4 thoughts on “Excel 2016 for Beginners Part 11: How to Format Dates in an Excel 2016 Spreadsheet

  1. I have a Mac and don't have the Control Panel settings. I went into Preferences and looked around and didn't find anything much like what is on your examples. I cannot get the dates to stop reverting to 7/19 with the current year attached to it. I want it to say July 19. I have tried clearing formulas, changing the formula to text, retyping until the cows came home, and trying to paste a formula from one of my worksheets where it DID put the date the way I want it. It won't budge out of 7/19. Can you direct me to the right place where I can figure this out? Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *