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?