Attach to value (Pro) is the placement auditors reach for on live schedules: the mark becomes part of the cell’s number format, not its contents.
Why that matters #
- The cell still contains
125400.5; it just displays as125,400.50 ✓. - Every formula that references the cell keeps calculating, because the value never changed.
- Remove tick marks strips the mark from the format and the cell displays exactly as before.
How to use it #
- Set Placement to Attach to value, select the figures, click a mark.
- Different marks stack: tick a cell, later add “F”, and the display reads
125,400.50 ✓ F. Clicking the same mark twice does nothing (it is already attached). - Color cell font optionally colors the whole cell’s font in the tick color, since a format literal cannot be colored separately.
- Empty cells in the selection get the mark as regular text (there is nothing to preserve); error cells are skipped and reported.
Good to know #
- Text cells work too: the mark is appended to the text section of the format, and the underlying text stays untouched.
- A cell with an extremely long or exotic custom format is skipped rather than risked; the summary tells you how many.
- Sign-offs and numbered steps respect the attach placement as well.