Formatting information copied and pasted from the WEB to excel

[jbsand1001]

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

[galimi]

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

[Gord Dibben]

Format the cells as General.

Copy a blank cell then select your range of data and Paste Special>Add>OK>Esc.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
<[email protected]> 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

[jbsand1001]

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 Special>Add>OK>Esc.
>
>
> Gord Dibben Excel MVP
>
> On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
> <[email protected]> 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 Dibben]

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 Tools>Add-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"
<[email protected]> 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 Special>Add>OK>Esc.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
>> <[email protected]> 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
>>
>>

[jbsand1001]

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 Tools>Add-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"
> <[email protected]> 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 Special>Add>OK>Esc.
> >>
> >>
> >> Gord Dibben Excel MVP
> >>
> >> On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
> >> <[email protected]> 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
> >>
> >>
>
>