Remove 0 in excel. 1.Open new sheet, 2.Copy data in the column from ur old sheet, 3.Right click in the new sheet, 4.Paste special, 5.Under the Operation select Add, 6.Now same way to return beck ur data to old sheet. Note: if u have data with symbols, 0123456+ or - or ?,remove that symbols.