Turning Off the Automatic Formatting of Dates

Shutting down automatic formation of dates in Microsoft Excel can be relatively easy. Let’s setup a scenario, where are sharing pizza among six people. We’d have data like this:

 

data table dates1. Right click on the cells you would like to add values to (1), then choose format cells (2).format cells

2. Choose number or any other category of your desire (1), and then click ok (2).

category formatting

Check also our date duration calculator.

Template

You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial