# Find hardcoded numbers in your Excel formulas, free.

> Find hardcoded numbers in Excel formulas, and typed values pasted over formulas, free. Runs in your browser; your file is never uploaded.

Page: https://formulaudit.com/free-tools/excel-hardcoded-values-finder

A free browser tool from Formula Audit XL. No data leaves your machine. Open the page, drop an .xlsx, .xlsm or .xls file on it, and read the summary counts and the sortable table of sheet, cell, formula and reason. Download the list as a CSV, or install the add-in to colour every hardcode live inside Excel.

## What this tool checks

- **Numbers typed inside formulas**: every formula is split into tokens, and the typed numbers left once references, names, text and error values are taken out are listed (for example the 1.2 in =B4*1.2).
- **Values typed over formulas**: a typed number that sits in a row or column of matching formulas, almost always a formula someone overwrote with its own result.
- Not flagged: 0, 1 and -1; 100 next to * or /; and bare numbers in structural arguments, such as the digits of ROUND or the column index of VLOOKUP.

## FAQ

### Is my Excel file uploaded anywhere?

No. The finder runs entirely in your browser using your device's memory. Your file and its contents never leave your machine, so it is safe for confidential models.

### What counts as a hardcoded value?

Two things. First, a number typed inside a formula, such as =B4*1.2 or =SUM(A1:A9)+500: the 1.2 and the 500 are assumptions hidden where nobody can see or change them. Second, a typed number in a row or column that is otherwise formulas: usually a value pasted over a formula, so that cell no longer updates.

### Which numbers are not flagged?

A short allow-list. 0, 1 and -1 are never flagged, because they are identities and tests (=A1*1, =IF(A1>0,...)). 100 is not flagged next to * or /, because =A1/B1*100 is a percentage conversion. And a bare number in a structural argument is not flagged: the digits of ROUND, the column index of VLOOKUP, the match type of MATCH, the function code of SUBTOTAL. Those choose how a function works, not a model input.

### Can it mistake a cell reference or a text for a number?

No. The formula is split into tokens before anything is checked, so the digits in A1, $B$7, 3:3, Sheet2!C4, LOG10, "Q4 2024" and #DIV/0! are never read as numbers. Scientific notation such as 1E+6 is read as one number.

### Why is the first value in a row not flagged?

A row of formulas usually starts from a typed value: an opening balance or a first-year actual. The finder only flags a typed value when formulas with the same pattern sit on both sides of it, or when it ends a run of matching formulas.
