How To Stop Changing Numbers to Dates Automatically in Excel

Опубликовано: 13 Сентябрь 2024
на канале: itech tips

56k

486

To Stop Changing Numbers to Dates Automatically in Microsoft Excel Document, do any one of the following methods:
Method 1:
Put an apostrophe (‘) before entering that number.
Method 2:
Before enter the numbers, select the columns where you will enter those numbers and then click “Cntrl” key + 1. In the opening window, select “Text” and then click “ok”. Now, enter the numbers.
I hope this video will be useful for you...! Please let us know which of these two methods worked with you by leaving a comment below… If this video benefited, don’t forget to like this one and subscribe my channel for the latest updates…! Thank you for watching…!!