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

J

jbsand1001

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,
 
M

Mike

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top