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

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,

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,

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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,
.

Go to ToolsOptionsTransition 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



On Thu, 10 Mar 2005 07:47:05 -0800, "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,