Minus
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Bullets
Command ID: btnMinusSign
What it does
Prepends a minus sign − plus a space to every line inside the selected cells. It is the lightest, most neutral marker in the menu, which makes it the natural second level under an item already carrying ● or a number — the components of a work item, or the small steps inside one activity.
Note that the character inserted is the mathematical minus − (U+2212), not the keyboard hyphen -. That is deliberate: it lets (None) recognise exactly the symbols the add-in inserted without cutting hyphens out of your own text.
How to use
- Select the cells that need bullets.
- Go to the DVD Addin tab → Text and Number group → open the Bullets menu → choose Minus.
- The add-in strips any existing bullet first, then handles each cell:
- Text cell —
−is added at the start of every line. - Empty cell — just
−is written. - Formula cell — wrapped as
=""&"− "&(original formula), so the marker shows while the formula stays live.
- Text cell —
- The status bar reports
Processed N cells (bullet −).
Example
The "Work components" column of a bid quantity schedule:
| Before | After |
|---|---|
| PCB40 cement Coarse sand Aggregate 1×2 Plasticiser admixture | − PCB40 cement − Coarse sand − Aggregate 1×2 − Plasticiser admixture |
Keeping ● on the parent item and − on its components gives the schedule a clear hierarchy without hand-made indentation.
Notes
- The inserted character is the minus
−(U+2212); a hyphen-you typed yourself is not recognised, so (None) will not remove it. - Cells holding numbers, dates, or TRUE/FALSE are skipped entirely.
- Text cells are switched to Text format (
@) before writing; formula cells keep their existing format. Ctrl+Zwill not undo the change.- Hidden rows and columns are skipped, and each merged area is processed once, at its top-left cell.
Related
- Filled circle — the first-level bullet that usually sits above these.
- Plus — the other plain ASCII marker in the menu, easy to retype by hand.
- (None) — strip the markers and return to plain text.
- Multilevel numbering — when the list needs
1.1.1.numbers driven by indent level.