Stop word from auto dating

If you check that box, Word inserts a date field rather than a static date.This field updates to the current date every time you open the document. Fw-300 .qstn-title #ya-trending-questions-show-more, #ya-related-questions-show-more #ya-trending-questions-more, #ya-related-questions-more /* DMROS */ .Whenever you eneter numbers separated by a hyphen in Microsoft Excel, it automatically converts that data into date format.

Click the Office Orb at top left, choose Prepare, and choose Properties.

Suppose you type “2-2” in Excel it becomes “02-Feb” automatically, so to prevent this automatic formatting of numbers into date in Excel follow simple steps below.

Method-1 Step-1 Select entire cells of a Workbook in Excel by pressing “Cmd” “A” (Mac), “Ctrl” “A” (Windows) and then right click on any cell and select the option “Format Cells…” from opened list Step-2 Select “Number” tab, and from the left panel select “Text” category Now, whenever you will enter numbers in a cell of this Worksheet, that will remain a number and will not be converted into date format.

Even if I try to manually change it, it nonetheless reverts back to the current day.

How do I stop the date from updating when opening documents saved under the old Template?

Leave a Reply