I've been working in several workbooks for the past couple of months with no problem. Then yesterday out of the blue I'm having problem every time I copy/past number from another sheet in the workbook or even from a workbook that I don't use very often, that it is always pasted in the Date Format, March 14, 2012. I've never had this happen before but it is very frustrating. I am attaching a file that shows a demonstration of it with more explanation.
32.8 KB Views: 9