Forum Discussion
extreme noob converting text to date
i am trying to setup a simple spreadsheet. When I enter the date, i prefer to type it in as follows using todays date 08182020. i would like to change that to show as 08/18/2020. I have tried usi...
If you right-click on the cell and select "Format Cells" from the drop down menu, then, in the new window that appears, select Date from the Category, you will be able to format the date any way you want. Highlight all the cells/columns that you are entering the date in and format them, then it will change your entries to your chosen date format.