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: Use commas to group thousands and a dot
for decimals (
1,000.50, not1.000,50or1,5). Currency symbols and spaces are ignored. -
Percentages: Include
%when comparing against percentage-formatted cells (50%equals0.5). -
Dates: Write
YYYY-MM-DD, use an English month name (8 Nov 2026), or pick Month/Day/Year or Day/Month/Year under Date order for numeric dates like11/8/2026. -
Conditions: Equal To and
Contains match case-insensitive text (including formatted display text
like
1,235), whereas Greater Than and Less Than require a valid number or date.
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:
-
Month/Day/Year: Reads
11/8/2026as November 8, 2026. - Day/Month/Year: Reads
11/8/2026as August 11, 2026.
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
-
Custom cell formatting: Excel date cells store the full calendar date
regardless of display format, so cells showing
8-NovorSundaystill match2026-11-08. -
Timestamps: Date comparisons ignore time of day, so a cell holding
November 8, 2026 2:24 PMequals2026-11-08. - Day rollover: A Date Within Days counts calendar days in Coordinated Universal Time (UTC), so the current day can advance a few hours before or after your local midnight.
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.