Prevent Excel from reformatting two numbers to a date and month
Topping my list of Microsoft Excel pet peeves is the program's automatic conversion of two numbers on either side of a hyphen into the date and month the numbers correspond to, such as "1-1" becoming "01-Jan."
The change occurs even when you choose any of the options available when you select Paste Special. I have looked high and low for a way to disable this setting in Excel, to no avail.
You can make the change for an entire worksheet by clicking the small box above 1 and to the left of A in the … Read more