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...
In addition, dates in Excel are actually sequential integer numbers starting from 1, which is represented as Jan 01, 1900, to the end of 9999 year. For example, Aug 20, 2020 if you enter this date and apply General format to it will be shown as 44063.
Thus formatting won't help, you shall use formula as JMB17 suggested or like to convert your texts into the dates.