excel numbers in general format i cant add cant change format

copied info from syspro report, pasted into excel, split cell info into more
collums. numbers are in general format, cant add them, i cant change the
format by formating the cell to numbers is there a way to reformat?

Try this:

Enter a 1 into any blank cell
Copy that cell
Select your data to convert
Paste Special
Select "Multiply"
Click OK
Delete the 1 you entered originally

This multiplies all of your data by 1. Any text that Excel can recognize as
a number, will be converted to a number.

HTH,
Elkar

"claude" wrote:

> copied info from syspro report, pasted into excel, split cell info into more
> collums. numbers are in general format, cant add them, i cant change the
> format by formating the cell to numbers is there a way to reformat?

claude

Copy an empty cell formatted to General.

Select your range of "numbers" and in place, Paste Special>Add>OK>Esc.

Should be good to go now.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 11:18:01 -0700, claude <claude@discussions.microsoft.com>
wrote:

>copied info from syspro report, pasted into excel, split cell info into more
>collums. numbers are in general format, cant add them, i cant change the
>format by formating the cell to numbers is there a way to reformat?

i have been trying to copy data from web pages, select - copy - past methode these are company financial data but i found that im not able to manypulate the data copied. i have tried a to change the cell format and even tried the above suggested methode it still dont work for me.

lokking foreard to help

thanks for your suggestion but it still does not work

i dont know if you will belive it

i tried to copy a sample data in this space for you to experiment then just to recheck copied it back in to excell ......



i works perfectly like a excell data now. i cant beliveit i have been trying to solve this for such a long time

do you have a reason for this
i still cant belive it