回複

來源: 於 2007-04-25 08:24:36 [舊帖] [給我悄悄話] 本文已被閱讀：次

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