Skip to content

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

  1. Select the cells that need bullets.
  2. Go to the DVD Addin tab → Text and Number group → open the Bullets menu → choose Minus.
  3. 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.
  4. The status bar reports Processed N cells (bullet −).

Example

The "Work components" column of a bid quantity schedule:

BeforeAfter
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+Z will not undo the change.
  • Hidden rows and columns are skipped, and each merged area is processed once, at its top-left cell.
  • 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.

Released under DVDAddin License.