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

請您先登陸，再發跟帖！