excel數字不能累加

If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see those numbers as text -- not real numbers.

如果將銀行對帳單數據下載到Excel中，或從網站復制號碼，則這些號碼可能無法正確累加。 銀行數據可能看起來像數字，但是Excel可能會將這些數字視為文本-而不是實數。

You can fix the numbers manually, as shown in the video below, or use a macro to automate the fix.

您可以手動固定數字，如下面的視頻所示，或使用宏自動進行修正。

數字不累加 (Numbers Don't Add Up)

There are a variety of reasons that numbers don't add up in Excel, and this technique fixes one of the more common problems. If it doesn't work on your data, check out some of the other fixes here.

不能在Excel中累加數字的原因有多種，這種技術解決了較常見的問題之一。 如果對您的數據不起作用，請在此處查看其他一些修復程序 。

Here is a screen shot of the sample data used in this video – it has cheque numbers and amounts from a fake bank statement. (If your bank only sends you this much information, you should switch to a different bank!)

這是此視頻中使用的示例數據的屏幕快照–它具有支票號碼和假銀行對賬單中的金額。 (如果您的銀行僅向您發送了這么多信息，則應切換到其他銀行！)

觀看視頻 (Watch the Video)

In the short video below, you will see how to check the cells, and then fix the problem. This is an update for a video that I did in May 2008 – and people are still watching that one on YouTube!

在下面的簡短視頻中，您將看到如何檢查單元格，然后解決問題。 這是我在2008年5月拍攝的一部視頻的更新-人們仍然在YouTube上觀看該視頻！

演示地址

用宏修正數字 (Fix the Numbers with a Macro)

Also, I've updated the macro that automates this fix, to prevent a problem. The old code used the full range that was selected, and that was okay, if you just selected the cells that you wanted to update.

另外，我還更新了自動解決此問題的宏，以防止出現問題。 如果您只是選擇了要更新的單元格，那么舊的代碼將使用所選的整個范圍，這沒關系。

However, if you selected an entire column, and then ran the macro, the Used Range was extended to that entire column.

但是，如果選擇了整個列，然后運行宏，則“已用范圍”將擴展到整個列。

Selection.PasteSpecial Paste:=xlPasteValues, _Operation:=xlPasteSpecialOperationAdd

In the revised code, it creates a range from the cells with constants in the selected range, and updates those cells.

在修改后的代碼中，它將從單元格中創建一個范圍，且常數處于選定范圍內，并更新這些單元格。

Set rng = Selection _.SpecialCells(xlCellTypeConstants, 23)

That seems to have eliminated the problem. You can get the entire code from my website, or by downloading the sample file.

這似乎消除了問題。 您可以從我的網站獲得完整的代碼，也可以下載示例文件。

下載樣本文件 (Download the Sample File)

To test the manual or macro fix, you can download the sample file from my website. The zipped file is in xlsm format, so enable macros when you open the file.

要測試手動或宏修復程序，您可以從我的網站下載示例文件 。 壓縮文件為xlsm格式，因此在打開文件時啟用宏。

翻譯自: https://contexturesblog.com/archives/2016/01/28/how-to-fix-excel-numbers-that-dont-add-up/

excel數字不能累加

總結

以上是生活随笔為你收集整理的excel数字不能累加_如何修复不累加的Excel编号的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。