What Most People Miss About NUM in Excel (It’s Not a Function)

By James Chen

It’s 3:12 PM on a Tuesday. You just pasted a list of 47 supplier IDs into column A, typed =VLOOKUP(A2,B2:C10,2,FALSE), and got #N/A. You double-click the cell, hit F2, and suddenly see num highlighted in gray inside the Function Arguments dialog — not in your formula, not in the sheet, just… there. You search ‘NUM Excel’ and land on forums full of people asking the same thing.

The Problem

You’re not seeing an error called #NUM! — that’s different. This num is lowercase, italicized, and lives inside Excel’s built-in dialogs or formula autocomplete hints. It’s not something you type. It’s not a function. And yet, it shows up everywhere: in the Function Arguments box for DATE, TIME, PERCENTRANK.INC, and dozens more. Worse, when you hover over it, Excel gives zero explanation.

Here’s what actually happens when you misread num as a command or variable:

Symptom Cause Fix
Formula shows #VALUE! after typing =DATE(num,3,15) You treated num as a cell reference or literal value — but it’s just a label telling you ‘enter a number here’ Replace num with actual numbers: =DATE(2024,3,15)
In Function Arguments dialog, num appears dimmed under PERCENTILE.INC — you click it, press Delete, and Excel replaces it with 0 You deleted a placeholder instead of entering your own value — Excel auto-filled with default (often meaningless) Click inside the field and type your range: C2:C50, not num
AutoComplete suggests NUM as you start typing — you select it and get #NAME? Excel has no NUM() function. That suggestion is a red herring from partial text match Ignore it. Type NUMBERVALUE( or ISNUMBER( if you need numeric logic
You copy-paste a formula from a forum that says =XIRR(values,num) and it fails The forum author used num as shorthand for ‘your guess rate’, not Excel syntax Substitute your estimate: =XIRR(B2:B12,A2:A12,0.08)

The Solution

num is Excel’s way of labeling a required numeric argument — like a sticky note taped to a blank form field. It’s not code. It’s not a function. It’s documentation baked into the UI. Here’s how to handle it without stress:

  1. Open the Function Arguments dialog: Select any cell, type =DATE(, then press Ctrl + A. You’ll see three fields: Year, Month, Day. The first two show num in gray italics — that’s your cue to replace them.
  2. Don’t delete — replace: Click the num field, then type 2024. Don’t press Backspace until it’s gone — just start typing over it. Excel won’t break the dialog.
  3. Use real data ranges, not placeholders: For =SUMIFS(sum_range,criteria_range1,criteria1), don’t leave sum_range as num. Type D2:D100 or select the range with your mouse.
  4. Check the tooltip while typing: As you enter =TIME(, Excel shows TIME(hour,minute,second) below the formula bar. Those words (hour, minute) are the same idea — descriptive labels, not syntax.

Let’s walk through a real fix. Say you’re calculating employee tenure using YEARFRAC but keep getting #VALUE!:

Employee Hire Date Current Formula (broken) Fixed Formula
Sarah Chen 2021-06-14 =YEARFRAC(num,TODAY()) =YEARFRAC(B2,TODAY())
James Okafor 2019-11-03 =YEARFRAC(A5,num) =YEARFRAC(B3,TODAY())
Priya Mehta 2023-02-28 =YEARFRAC(num,num) =YEARFRAC(B4,TODAY())
Diego Ruiz 2020-09-17 =YEARFRAC(C7,1) =YEARFRAC(B5,TODAY())
Anya Petrova 2022-07-09 =YEARFRAC(DATE(num,1,1),TODAY()) =YEARFRAC(DATE(YEAR(B6),1,1),TODAY())

Notice how every num was replaced with either a cell reference (B2), a function (YEAR(B6)), or TODAY(). That’s the pattern. num vanishes once you supply real input.

Going Further

You’ll also see number, num_digits, num_trials, and num_periods — all variations of the same idea. But here’s the counterintuitive part: some functions require num to be *text that looks like a number*. Example: NUMBERVALUE("3.14159", ".", ",") converts formatted text to a true number. In that case, the first argument isn’t labeled num — but if you misread it as ‘just put a number’, you’ll pass 3.14159 directly and get #VALUE!. The function expects text.

Other places num-style labels appear:

  • In Data Validation dialogs: ‘Data: Decimal’, ‘Minimum: num’, ‘Maximum: num’ — again, just labels.
  • In Goal Seek: ‘To value: num’ — type 50000, not num.
  • In PivotTable Calculated Fields: when defining formulas, Excel shows num in the ‘Name’ box — ignore it. Name your field something meaningful like ProfitMargin.
  • In Power Query Editor, when changing data types: ‘Transform > Number > Round’ shows num_digits — enter 2, not num.

One pro tip: If you’re building a template for others, don’t use num in your own cell comments or notes. It confuses people. Use [enter year] or [sales qty] instead. Clarity beats convention.

When NOT to Use This

This rule doesn’t apply to #NUM! — that’s a real error. If you see #NUM! in a cell, it means Excel tried to calculate something impossible: =SQRT(-4), =LOG(-1), or =RATE(1000,500,100000) with no feasible solution. That’s math, not labeling.

Also avoid this logic with array formulas (pre-365). In legacy CSE formulas, num might appear in the formula bar as part of an evaluated result — but it’s not editable. Press F9 to force recalc, or switch to dynamic arrays.

And never assume num means ‘any number’. Some functions demand specific ranges: WEEKDAY expects 1–7 or 1–14 depending on return_type. Entering 99 where num sits will give #NUM! — not because the label was wrong, but because the value violates constraints.

Finally: if you’re using Excel for Mac, the Function Arguments dialog uses value more often than num, but the principle is identical. Same behavior. Same fix.

Keyboard Shortcuts

These shortcuts save time when navigating function arguments and fixing num-related confusion:

Shortcut Action When to Use It
Ctrl + A Opens Function Arguments dialog for active function Right after typing =SUM( or any function
Alt + M + M Opens ‘Insert Function’ dialog (same as Shift + F3) When you forget the function name or need category browsing
F9 Evaluates selected portion of formula in formula bar To test if num has been replaced correctly — highlight B2 inside =YEARFRAC(B2,TODAY()) and press F9
Ctrl + ` (backtick) Toggles between formula view and result view To quickly spot lingering num text in cells (though it rarely appears there — usually only in dialogs)
Alt + = Inserts SUM for selected range Bypasses num entirely — no dialog, no placeholders
James Chen

James Chen

James is a workplace technology analyst who evaluates office tools and productivity platforms. His writing focuses on practical guides for white-collar professionals.