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

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

Any advice?

所有跟帖： 

• manually input in one cell, than copy and paste to the others -暈乎- ♂ (0 bytes) () 04/25/2007 postreply 01:08:05

• copy and paste->都成同一個值了 -win2suse- ♀ (0 bytes) () 04/25/2007 postreply 03:17:01

• paste special -ppzcgg- ♀ (0 bytes) () 04/25/2007 postreply 08:23:46

• 回複 -毛毛爸- ♂ (163 bytes) () 04/25/2007 postreply 08:24:36