看板 Office 關於我們 聯絡資訊
軟體:excel 版本:2010 各位版友大家好,我想請教有關座標運算的問題。 請問要怎麼把附檔A到B範圍裡只有Y軸後面的數字加上5呢? http://ppt.cc/r82J 內容如下。 % O0100 G40G49G90G80 G17G00G55X0.Y0. /G05.1 Q1 (TOOL: R3_SC23) M03S8000 G43Z77.066H1 M8 G00X-3.537Y-32.185 Z50. Z46.933 Z36.933 G01Z26.933F3000. X-59.338 X-59.774Y-32.174 X-60.212Y-32.139 X60.951Y-32.027 X60.45Y-32.11 (----------A--------------) X59.947Y-32.162 X59.338Y-32.185 X-4.137 Z36.986 X69.797Y-4.643Z37.19 Z27.137 X69.801Y-9.886Z27.135 X69.82Y-15.771Z27.129 X69.86Y-20.655Z27.117 X69.909Y-23.534Z27.105 X69.905Y-23.985Z27.104 X69.852Y-24.918Z27.097 X69.817Y-25.385Z27.087 X69.747Y-26.094Z27.066 X69.645Y-26.813Z27.037 X69.556Y-27.293Z27.015 X69.445Y-27.772Z26.99 X69.308Y-28.247Z26.966 X69.144Y-28.716Z26.942 X68.953Y-29.176Z26.919 X68.735Y-29.624Z26.899 X68.489Y-30.059Z26.884 X68.214Y-30.477Z26.873 X67.909Y-30.875Z26.869 X67.577Y-31.251Z26.871 X67.217Y-31.602Z26.881 X66.836Y-31.929Z26.894 X66.441Y-32.242Z26.905 X66.041Y-32.548Z26.91 X65.774Y-32.715Z26.923 X65.293Y-32.998Z26.94 X64.672Y-33.32Z26.959 X64.036Y-33.603Z26.976 X63.388Y-33.847Z26.991 X62.729Y-34.051Z27.005 (----------------B--------------) X62.062Y-34.215Z27.017 X61.39Y-34.338Z27.027 X60.714Y-34.421Z27.036 X60.067Y-34.462Z27.043 X59.359Y-34.465Z27.05 X57.354Y-34.415Z27.065 X55.349Y-34.393Z27.072 X52.922Y-34.394 X51.665Y-34.403Z27.069 X49.923Y-34.428Z27.061 X46.921Y-34.5Z27.038 X44.169Y-34.594Z27.006 X41.169Y-34.723Z26.957 X38.419Y-34.861Z26.896 X36.419Y-34.971Z26.842 X32.669Y-35.19Z26.718 X28.669Y-35.424Z26.557 X24.92Y-35.626Z26.391 X20.671Y-35.826Z26.195 X18.171Y-35.926Z26.082 X15.422Y-36.021Z25.965 X12.423Y-36.104Z25.852 X9.673Y-36.162Z25.764 X6.674Y-36.209Z25.69 X4.799Y-36.229Z25.657 X2.925Y-36.243Z25.634 X-.075Y-36.251Z25.619 X-2.002Y-36.248Z25.625 X-5.001Y-36.229Z25.658 X-6.965Y-36.207Z25.693 X-10.428Y-36.151Z25.782 X-13.391Y-36.083Z25.881 X-16.354Y-35.996Z25.997 X-18.817Y-35.908Z26.104 X-22.78Y-35.738Z26.285 X-26.707Y-35.541Z26.465 X-30.67Y-35.317Z26.634 X-34.633Y-35.083Z26.781 X-38.561Y-34.862Z26.896 X-40.561Y-34.759Z26.941 X-43.491Y-34.627Z26.994 X-46.491Y-34.518Z27.033 X-49.422Y-34.441Z27.057 X8.005Y-39.021Z21.134 X8.411Y-39.055Z21.067 X8.806Y-39.086Z21.013 X9.193Y-39.112Z20.976 X9.667Y-39.139Z20.964 X9.967Y-39.152Z20.973 Z37.12 X.225Y38.546Z37.992 Z21.845 X-.342Y38.548Z21.809 X-2.042Y38.556Z21.814 X-4.846Y38.597Z21.84 Z31.84 G00Z41.84 Z50. X0.Y0. /G05.1 Q0 M09 G00Z77.066 X0.Y0. M05 M30 % 感謝~ -- 錢會變薄,資產會縮水。 通通花光才有100%的享受, 這就是活在當下。 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.234.41.103 ※ 文章網址: http://www.ptt.cc/bbs/Office/M.1414891465.A.6BB.html
soyoso: http://goo.gl/9Z4ana 試試 11/02 12:24
topgunguy: 太神了 11/02 13:35
topgunguy: 請問S大,這篇如果要用在2003需要做什麼設定呢?我用 11/07 00:12
topgunguy: 2010開起後存成2003版但是不行。 11/07 00:12
soyoso: http://goo.gl/E12D55 試試 11/07 07:38
topgunguy: 感謝 11/09 12:54