http://www.contextures.com/xlDataEntry03.html#PasteSpecial using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial Trailing Minus Signs macro http://www.contextures.com/xlDataEntry03.html using Paste Special > Add using Paste Special > Add using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial using Paste Special > Add Convert with Paste Special Trailing Minus Signs macro http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html http://www.contextures.com/xlDataEntry03.html using Paste Special > Add using Paste Special > Add using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial lots of ways to do that change text to real numbers http://www.contextures.com/xlDataEntry03.html#PasteSpecial Convert Text to Numbers Trailing Minus Signs macro Trailing Minus Signs macro Trailing Minus Signs macro http://www.contextures.com/xlDataEntry03.html using Paste Special > Add http://www.contextures.com/xlDataEntry03.html http://www.contextures.com/xlDataEntry03.html http://www.contextures.com/xlDataEntry03.html using Paste Special > Add Fix Hidden Characters With VBA solutions for fixing numbers that don't add up using Paste Special > Add using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial convert the text values to numbers using Paste Special > Add lots of ways to do that using Paste Special > Add Convert Text to Numbers Fix Numbers that don't add correctly http://www.contextures.com/xlDataEntry03.html#PasteSpecial using Paste Special > Add Trailing Minus Signs macro http://www.contextures.com/xlDataEntry03.html#PasteSpecial using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial Trailing Minus Signs macro using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial Trailing Minus Signs macro using Paste Special > Add http://www.contextures.com/xlDataEntry03.html using Paste Special > Add http://www.contextures.com/xlDataEntry03.html using Paste Special > Add http://www.contextures.com/xlDataEntry03.html#PasteSpecial using Paste Special > Add http://www.contextures.com/xlDataEntry03.html http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html http://www.contextures.com/xlDataEntry03.html http://www.contextures.com/xlDataEntry03.html#PasteSpecial http://www.contextures.com/xlDataEntry03.html#PasteSpecial