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

来源: win2suse 于 2007-04-25 00:15:59 [] [博客] [旧帖] [给我悄悄话] 阅读数 : (96 bytes)

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- ♀ 给 win2suse 发送悄悄话 win2suse 的博客首页 (0 bytes) () 04/25/2007 postreply 03:17:01

• paste special -ppzcgg- ♀ 给 ppzcgg 发送悄悄话 ppzcgg 的博客首页 (0 bytes) () 04/25/2007 postreply 08:23:46

• 回复 -毛毛爸- ♂ 给 毛毛爸 发送悄悄话 (163 bytes) () 04/25/2007 postreply 08:24:36

请您先登陆，再发跟帖！