How to change the date format to a general numeric format? You may also need to know how to convert the date form a date format into a general format, for example 14/01/2022 > 14012022. Right-click on ...
Or, use a formula like =TEXT(A1,"mm/dd/yyyy") to convert it manually. Another option is =DATEVALUE(A1) But if you’ve tried all of that and it still shows as text or ...