How To Stop Changing Numbers to Dates Automatically in Excel
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…!!
Watch video How To Stop Changing Numbers to Dates Automatically in Excel online, duration 01 minute 23 second in high hd quality that is uploaded to the channel itech tips 11 June 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 56 thousand times and liked it 486 visitors.
