Hi, what I do in cases like this is to paste the info into Word first, do a
replace - stripping out the = sign and then copy and paste into exel.

hope this helps, Mike

"jbsand1001" wrote:

I have some data that I copied off a website and pasted into an excel
spreadsheet but I do not get the value that is displayed on the website. For
example....

The information that was copied was a phone and fax number 1-555-555-5555
but when I put this information into my excel sheet I get -4500. If I look
into the cell the cell looks like =1-555-555-5555. I need a way to remove
the "=" from each one of these cells.


Thank You,