How Alerts for Excel Reads Numbers, Percentages, and Dates

A number sign

Summary

This post shows you how to format numbers, percentages, and dates in the Value field of an Alerts for Excel check so your alerts trigger reliably.

You can enter values the way your worksheet displays them (such as $1,000, 50%, or 8 Nov 2026). When you select Save check on a greater-than or less-than rule, the editor validates Value against these rules:

Numbers

Commas group thousands and a dot marks decimals. Alerts for Excel strips spaces and currency symbols without converting between currencies ($100 and €100 both equal 100):

Format Examples you can enter Read as
Whole numbers & thousands 1000, 1,000, 1 000 1000
Decimals 1,000,000.25, 4.5, .5 1000000.25, 4.5, 0.5
Currency $100, €100, £ 100 100
Negative & accounting -100, (100), -$100, ($100) -100

Greater-than and less-than checks reject ambiguous or non-numeric formats when you save:

Unsupported value Why it is rejected Enter instead
1,5 or 1.000,50 Decimal commas mean different numbers across regions; commas must group three digits and dots mark decimals. 1.5 or 1,000.50
12 kg Measurement units are treated as text rather than part of a number. 12
1e3 Scientific notation is not supported. 1000

Percentages

Excel stores a cell displaying 75% as 0.75. Include % in Value so Alerts for Excel divides the number by 100 and compares both values on the same scale:

Value you enter Cell displays Does Greater Than match?
50% 75% Yes. 0.75 is greater than 0.5.
0.5 75% Yes. 0.5 and 50% represent the same number.
50 75% No. The cell stores 0.75, which is less than 50.

Dates

Alerts for Excel accepts dates written in three formats:

Format Examples you can enter
Year first (unambiguous) 2026-11-08, 2026/11/08
English month name 8 Nov 2026, 8-Nov-26, November 8, 2026
Numeric day, month, and year 11/8/2026, 11/8/26, 8.11.2026, 08-11-2026 (interpreted using the check's Date order)

Two-digit years always map to 2000 to 2099 (11/8/26 means 2026). Write all four digits for years before 2000.

Date checks reject incomplete, non-English, or nonexistent calendar dates:

Unsupported value Why it is rejected Enter instead
Nov 8 Dates require a year. Nov 8, 2026
8 novembre 2026 Only English month names are supported. 8 November 2026 or 2026-11-08
2026-02-30 February has 28 days in 2026. 2026-02-28

Date order for numeric dates

A date like 11/8/2026 means November 8 in the United States and August 11 in most other regions. Whenever you enter an all-numeric day/month/year date (or choose A Date Within Days), the check editor displays a Date order setting beneath Value:

New checks default to Month/Day/Year when Excel runs in English (United States) and Day/Month/Year in all other languages. Date order does not affect year-first dates (2026-11-08) or English month names (8 Nov 2026).

How date cells compare

How each condition compares cells

Compare each condition to see what cell values match (Not Equal To, Does Not Contain, and Not Empty invert the results of Equal To, Contains, and Empty):

Condition Matches when Does not match when
Equal To The cell stores the same number or date, or displays the same text (case-insensitive, so done matches Done). Accepts any text. The text differs beyond letter case (for example, done vs. Done!).
Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To Value and the cell are both valid numbers or both valid dates, and the comparison holds. The cell is empty or holds non-numeric text such as N/A.
Contains The cell's displayed text includes Value in any letter case (urgent matches This is URGENT). The displayed text does not contain Value.
Empty The cell is blank or holds a formula that returns empty text (""). The cell holds 0 (zero counts as a value, not an empty cell).
A Date Within Days The cell holds a date from today through the next N days (entering 3 matches today and the next 3 days). The date is in the past, or the cell does not hold a valid date.

Formatted display text and imported text cells

Equal To matches both the raw number a cell stores and the rounded or formatted text it displays, so copying what you see in Excel works directly:

Cell stores Cell displays Value you enter Does Equal To match?
1234.567 1,235 1,235 Yes, by the displayed text.
1234.567 1,235 1234.567 Yes, by the stored number.
1234.567 1,235 1,236 No.

When a cell stores a number or date as plain text (for example, after a CSV import), Alerts for Excel parses that text using the same rules and Date order as Value: a text cell holding $1,000 is greater than 100, while a text cell holding 1,5 is treated as non-numeric text.

Sorted or inserted rows

Alerts for Excel tracks each watched cell by its address, such as B2. Sorting a watched range or inserting rows above it moves values to new addresses, so a check can send an alert for a value that moved without changing.

For help with Alerts for Excel, contact support.