回复

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

请您先登陆，再发跟帖！