If an Excel total omits imported amounts, check whether those cells contain text, then convert only the amount range in a copy of the workbook. Leave invoice IDs alone: 00041 identifies a record and should not become the arithmetic value 41.
Confirm the cell type before changing the column
Use =ISNUMBER(B2) and =ISTEXT(B2) in spare cells to inspect a suspect amount. Microsoft's IS function reference explains that these tests do not convert the input: text that looks numeric still fails ISNUMBER.
Left alignment is only a clue. Excel lets users set cell alignment independently, so a number can be left-aligned and text can be right-aligned. Changing alignment cannot repair a total.
Also inspect the total's formula range. A correctly typed amount outside =SUM(B2:B4) remains outside that calculation. Microsoft documents that SUM ignores text in referenced cells; that explains a missing amount only after you have confirmed both the range and the type.
Keep the received workbook untouched and save a working copy such as invoice-import-review.xlsx. Record which column contains amounts and which contains identifiers. Do not select the entire sheet for a bulk conversion simply because both columns contain digits.
Choose the conversion method available in your Excel edition
On Windows desktop Excel, select only the affected amount cells, open their error indicator, and choose Convert to Number. If the indicator is absent, a helper column offers a visible before-and-after comparison. Microsoft's conversion instructions cover both approaches and provide a separate VALUE workflow for Excel for the web.
The page checked on October 4, 2026 lists Excel for Microsoft 365, 2024 and 2021, including their Mac editions, plus Excel 2019, 2016 and Excel Web App. The error-indicator menu path above follows its Windows section; do not assume a Mac or web interface has identical controls. Use the helper method when the menu differs. These are documentation-verified instructions, not a claim that each edition was run for this article.
For the helper method, label C1 Converted amount, enter =VALUE(B2) in C2, and fill down only through the imported records. Keep the original B column beside it until the checks below pass. VALUE interprets text using number, date or time formats Excel recognizes, so first establish that the source field really contains amounts.
Reproduce a three-invoice example before touching the real import
This illustrative exercise has a known answer: the three amounts total 160, while all three IDs retain five characters. It is a reproducible check for your Excel installation; the workbook exercise was not executed for this article.
In a new test workbook, put Invoice ID in A1 and Imported amount in B1. Set A2:A4 and B2:B3 to Text using Home > Number Format > Text before entering anything. Keep B4 in General format. Microsoft's text-format guidance currently lists Microsoft 365, Excel 2024 and Excel 2021 for this menu.
- In row 2, enter ID
00041and amount125into the text-formatted cells. - In row 3, enter ID
00042and amount40into the text-formatted cells. - In row 4, enter ID
00043and the numeric amount-5into B4.
Before conversion, =SUM(B2:B4) should return -5. =ISNUMBER(B2) should be FALSE, while =ISTEXT(A2) should be TRUE. If those results differ, correct the sample's input types before continuing; visual resemblance is insufficient.
In C2 enter =VALUE(B2) and fill through C4. Expected C2:C4 results are numeric 125, 40 and -5; =SUM(C2:C4) should return 160. Check each result with ISNUMBER, and check each original ID with ISTEXT plus a direct comparison against 00041, 00042 and 00043. A total alone could hide two offsetting mistakes.
When the equivalent checks pass on your real working copy, you may keep the helper column. If the existing total must continue referencing B, copy the verified C cells and use Home > Paste > Paste Special > Values on the corresponding B range. Never include A in that selection. Recheck B's total and the IDs, save the working XLSX, close it, and reopen it for the same checks.
Resolve failures without hiding the bad records
If VALUE returns #VALUE!, isolate that row and compare it with the source record. Unrecognized separators, currency text or other characters can prevent conversion. Confirm whether 1,250 means one thousand two hundred fifty or a decimal amount in the source's convention before altering punctuation. Request a consistent amount export when the convention is unclear; do not replace every failed conversion with zero.
If C contains numbers but the original total still excludes them, the total may still reference B. Either total the reviewed helper range or complete the deliberate values-only replacement. Check the start and end references as well; converting cells does not decide which records belong in the total.
If IDs lose zeros, undo the accidental conversion or recover the affected column from the untouched source. Formatting an already changed ID as Text does not establish its original characters. Microsoft also documents Excel's 15-digit numeric precision limit, which is another reason to exclude long identifiers from amount conversion.
Treat blanks, refunds and subtotal rows deliberately. A blank is not automatically a zero; a negative amount may be a valid adjustment. Keep the import's record count and an independently supplied control total alongside the workbook, and investigate discrepancies before sending the file onward.
Use a preview for layout, then verify types in Excel
The CSV / Excel Online Preview can help inspect a separate, non-sensitive review file's headers and rows. The current csv-preview component accepts CSV, TSV, XLSX and XLS, offers sheet selection when applicable, and searches extracted values. It cannot inspect or repair Excel cell types, evaluate formulas, or edit the selected workbook.
Its parser can infer values when reading CSV, including changing the representation of leading-zero IDs. A preview that shows 41 therefore cannot establish whether Excel stored 00041 correctly. Check identifiers against the untouched source and verify the workbook's types inside Excel; use the browser view only for the limited structural question it can answer.
Only the first 500 matching data rows are rendered. Search filters the display, while Export CSV includes the opened sheet's entire extracted data. Do not use that button to create an amount-only or privacy-filtered delivery. It makes a separate CSV and cannot preserve the workbook's formulas or formatting. The component loads its parser from a CDN before parsing locally, so an initial network dependency can also prevent previewing.
Common questions
Should I convert every green-triangle cell?
No. A text-stored invoice ID may be intentional. Decide whether the field represents an amount before applying any conversion.
Does changing Text to Number format prove the cells are fixed?
No. Recheck the actual values with ISNUMBER and reconcile the total. A display-format choice is not the verification step.
Why keep a helper column after the total looks right?
It preserves a row-by-row comparison with the imported strings. Keep it until you have reviewed exceptions and the source IDs, then decide which columns the downstream file needs.
Can I use VALUE on dates and still call them amounts?
No. VALUE recognizes more than amount strings, including supported date and time representations. Confirm the column's meaning before converting it and investigate unexpected numeric results.
Can ToolboxHub certify that the workbook now calculates correctly?
No. The preview displays extracted data. Verify formulas, numeric types, exact IDs and the independently known total in Excel, then check the saved workbook again.