In case you do not want to use the predefined date or time format, you can change them in Google Sheet and Excel Online. For your information, you do not need to use an add-on or any other third ...

If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date. 4. Excel offers many other date format choices. In the cell format menu, click on "More ...

In a program like Excel, which is designed to handle numbers, you'd expect to be able to use fractions without any hiccups.

Note: We have included screenshots of Excel ... this format. You need to expand this list and choose a file format as per your requirements. At last, click the OK button to save the change.