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? |
excel numbers in general format i cant add cant change format
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? |
excel numbers in general format i cant add cant change format
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? |
All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com