When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom

Judd,

The cells may be formatted as text. Try formatting them as General.

http://HelpExcel.com

"jbsand1001" wrote:

When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom

Format the cells as General.

Copy a blank cell then select your range of data and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
wrote:

When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom

Thank you but I think the problem is that the data I am trying to copy and
paste is from a website and it maybe in HTML format?

I tried both suggestions but nothing. Anything else?




"Gord Dibben" wrote:

Format the cells as General.

Copy a blank cell then select your range of data and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
wrote:

When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom

Probably has some non-breaking spaces(char 160) and other junk.

Run David McRitchie's Trimall macro on it.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Or prior to the above.......

Download Chip Pearson's CELLVIEW add-in from

http://www.cpearson.com/excel/CellView.htm

Load through ToolsAdd-ins.

Select the data and Chip's add-in will show you what the characters are in the
cells.


Gord

On Thu, 31 Mar 2005 19:21:01 -0800, "jbsand1001"
wrote:

Thank you but I think the problem is that the data I am trying to copy and
paste is from a website and it maybe in HTML format?

I tried both suggestions but nothing. Anything else?




"Gord Dibben" wrote:

Format the cells as General.

Copy a blank cell then select your range of data and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
wrote:

When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom

Gord,

Excellent!!!!!!! Thanks for your suggestions.



Judd
"Gord Dibben" wrote:

Probably has some non-breaking spaces(char 160) and other junk.

Run David McRitchie's Trimall macro on it.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Or prior to the above.......

Download Chip Pearson's CELLVIEW add-in from

http://www.cpearson.com/excel/CellView.htm

Load through ToolsAdd-ins.

Select the data and Chip's add-in will show you what the characters are in the
cells.


Gord

On Thu, 31 Mar 2005 19:21:01 -0800, "jbsand1001"
wrote:

Thank you but I think the problem is that the data I am trying to copy and
paste is from a website and it maybe in HTML format?

I tried both suggestions but nothing. Anything else?




"Gord Dibben" wrote:

Format the cells as General.

Copy a blank cell then select your range of data and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
wrote:

When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom