How to subtract a number from all the cells of a column in Excel

来源: 于 2007-04-25 00:15:59 [博客] [旧帖] [给我悄悄话] 本文已被阅读：次

I have tried my hand with formula like:
A1:A100-123
but doesn't work.

Any advice?