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?