回複

來源: 毛毛爸 於 2007-04-25 08:24:36 [] [舊帖] [給我悄悄話] 閱讀數 : (163 bytes)

in column B
B1=A1-123, then copy down to B100=A100-123
select B1:B100, copy -> paste_special -> values
column B will have numbers that 123 less than col A

請您先登陸，再發跟帖！