SirNo, you select every target cell use the Ctl key, then type 100 and hit Ctl-Enter.
SirNot really, that would just show the results, not how to do it.
It wasn't a formula, it was selecting all cells using Ctl-Click and then type 100 and hit Ctl-Enter.