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 SpecialAddOKEsc.

Should be good to go now.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 11:18:01 -0700, 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?