How to show a plus sign on positive numbers
✓ Verified in LibreOffice 25.8.7.3Display +5 / -3 for changes and deltas — scoreboards, diffs, growth columns.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | +0;-0;0 | A custom NUMBER FORMAT (Ctrl+1 → Custom) — the value stays numeric. +0.0%;-0.0%;0% for percentages. |
| Google Sheets | +0;-0;0 | Format → Number → Custom number format. Identical. |
| LibreOffice Calc | +0;-0;0 | Format → Cells → Number. Identical. |
How it works
The three format sections (positive;negative;zero) let you prefix a literal + on just the positive branch: 5 displays as +5, negatives keep their minus, zero stays plain (the verification proves the format string via TEXT). Because it's formatting, sums and charts still see real numbers — unlike concatenating a "+" which produces text. The same idea styles deltas green/red: [Green]+0;[Red]-0;0.
Verified, not just documented
We ran =TEXT(A2,"+0;-0;0") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned +5 — exactly the expected result. Every formula here is confirmed by actually executing it.