|I'm having a problem in Excel 2010 where when I copy a cell and then try and paste special as values or format, I am only given the option as pasting as text. I've seen this before in previous version on excel when you have two sessions of excel open at the same time and try and copy something from one session and paste it into a workbook in the other. However in this case I've within the same workbook, and sheet as well.|
I've recently started using Excel 2010 and think I may have inadvertently tweaked one of the new options?
Any help would would be much appreciated.