The pasted text will retain the formatting from the website. To paste plain text instead, first paste it into Notepad or a similar text editor, then copy and paste it again into Excel.

Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

Method for Excel 2010 For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu.

This kind of problem in Excel can be difficult to solve using standard paste techniques. It is likely that you will have to accept the paste as text and then manipulate the text entries to change the ...