Thread: excel numbers in general format i cant add cant change format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote