回复

来源: 于 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