Hi,
I frequently copy numbers from a web page and paste them into my Excel file. When I paste the number into a cell, Excel preserves its font family, font size and color. I want to paste only the value of that number, without the style. Is this possible (without having to double click the cell or right click and select special > text every time I will paste)?
I'm using Excel 2007.
Thanks for any ideas.
I frequently copy numbers from a web page and paste them into my Excel file. When I paste the number into a cell, Excel preserves its font family, font size and color. I want to paste only the value of that number, without the style. Is this possible (without having to double click the cell or right click and select special > text every time I will paste)?
I'm using Excel 2007.
Thanks for any ideas.
Last edited: