Why Numbers in Excel Not Adding?
Periodically, You May Encounter Numbers in Excel That You Can't Sum or Use Arithmetically. a Common Cause for This Is Numbers Formatted as Text. Often, Reports...
Periodically, you may encounter numbers in Excel that you can't sum or use arithmetically. A common cause for this is numbers formatted as text. Often, reports exported from other programs, such as an accounting package, will be formatted as text or they might contain embedded spaces.
How do you fix Excel numbers that don't add up?
- Select the cells that contain the numbers to be fixed.
- On the Ribbon's Home tab, click Find & Replace (at the far right)
- Click Replace.
- For Find what, press the Alt key, and on the number keypad, press 0160 (nothing will appear in the box)
- For Replace with, leave the box empty.
- Click Replace All.
Why is Excel not adding numbers correctly?
The SUM function does not add up any values when there are spaces in its formula. Instead, it will display the formula in its cell. To fix that, select the formula's cell; and then click in the far left of the function bar. Press the Backspace key to remove any spaces before the '=' at the beginning of the function.
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
