How do I delete the "=" from a cell to give me the phone number I.

[Guest]

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,

 

[Guest]

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

 

[Jason Morin]

Select your data and press Ctrl + H.
Find What: =
Replace With: >>leave empty<<
Click "Replace All".

HTH
Jason
Atlanta, GA

 

[Gord Dibben]

Go to Tools>Options>Transition and uncheck the "Transition Formula Evaluation"
and "Transition Formula Entry".

This is the cause of your problem to start with and further imports should
work properly without making changes after the fact.


Gord Dibben Excel MVP