excel numbers in general format i cant add cant change format

C

claude

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?
 
E

Elkar

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
 
G

Gord Dibben

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
 
Top