easy:

insert a colume first by the colume that has the data you want to modify. Let's say the colume A has the data, colume B is the new colume. In the first cell of colume B (say it is B1), type =A1-100.
Copy B1 and paste it to all other cells of the colume B. It's done.
You may delete colume A afterwards if you like.

所有跟帖： 

• you can not delete column A -xfyfz- ♀ (302 bytes) () 10/06/2005 postreply 05:44:55

• thanks! You are right. -雞毛蒜皮- ♀ (0 bytes) () 10/06/2005 postreply 05:51:50

• np :-p -xfyfz- ♀ (0 bytes) () 10/06/2005 postreply 05:53:53

• 回複：easy: -tofuTnT- ♀ (143 bytes) () 10/06/2005 postreply 07:50:18

• 更勝一籌,謝謝! -雞毛蒜皮- ♀ (0 bytes) () 10/06/2005 postreply 08:15:16

• 回複：easy: -鍾國仁- ♂ (23 bytes) () 10/06/2005 postreply 18:59:14