老师，在电子表格中，知道身份证提取出来的出生年月不可以复制粘贴到另外一个表，怎么处理

可以尝试将提取出来的出生年月改成文本格式后再复制粘贴

你好，重新打开复制下，有时复制过程程序有问题会出现这种情况的！复制的粘贴到的位置有没筛选

你好，直接复制过去，然后用格式刷刷一下就好了。

你好，选择要复制的内容，可以定位出可见单元格，然后再复制粘贴，或者选择后ALT加； 然后复制粘贴

你好同学看看这个有具体操作过程！ https://7dapi7.smartapps.baidu.com/pages/article/article?eid=154b4631a4b48569cb8f4138&scene=10810008&from=&_swebfr=1&_swebFromHost=vivobrowser&bdswankey=vivobrowser%3A%2F%2Fswan%2FGeVyFwtN81ARbPF3GIbuaPlRPT3SfzYB%2Fpages%2Farticle%2Farticle%3Feid%3D154b4631a4b48569cb8f4138%26word%3D4%25E8%25A1%258C%25E7%259A%2584%25E5%25AD%2597%25E5%25A4%258D%25E5%2588%25B6%25E5%259C%25A8%25E4%25B8%2580%25E8%25A1%258C%25E6%2580%258E%25E4%25B9%2588%25E6%2593%258D%25E4%25BD%259C%26oauthType%3Dsearch%26searchParams%3D%257B%2522failUrl%2522%253A%2522https%253A%252F%252Fjingyan.baidu.com%252Farticle%252F154b4631a4b48569cb8f4138.html%2522%252C%2522logParams%2522%253A%2522pu%253D%2524pu%2526baiduid%253D%2524baiduid%2526tcreq4log%253D1%2526isAtom%253D1%2526cyc%253D1%2526clk_info%253D%257B%255C%2522tplname%255C%2522%253A%255C%2522www_jingyan_normal%255C%2522%252C%255C%2522srcid%255C%2522%253A1599%252C%255C%2522ivkStatus%255C%2522%253A%255C%2522new_ivk_success%255C%2522%252C%255C%2522type%255C%2522%253A%255C%2522xcx%255C%2522%252C%255C%2522naType%255C%2522%253A%255C%2522%255C%2522%252C%255C%2522ivkSource%255C%2522%253A%255C%2522h5_schema%255C%2522%252C%255C%2522jumpType%255C%2522%253A%255C%2522xcx%255C%2522%252C%255C%2522jumpId%255C%2522%253A110%252C%255C%2522xcx_path%255C%2522%253A%255C%2522%2525252Fpages%2525252Farticle%2525252Farticle%2525253Feid%2525253D154b4631a4b48569cb8f4138%255C%2522%252C%255C%2522xcx_id%255C%2522%253A%255C%2522GeVyFwtN81ARbPF3GIbuaPlRPT3SfzYB%255C%2522%252C%255C%2522xcx_from%255C%2522%253A%255C%25221081000810003000%255C%2522%257D%2526lid%253D8136188885506825130%2526l%253D1%2526t%253Diphone%2526ref%253Dwww_iphone%2526from%253D1019311a%2526order%253D1%2526w%253D0_10_4%25E8%25A1%258C%25E7%259A%2584%25E5%25AD%2597%25E5%25A4%258D%25E5%2588%25B6%25E5%259C%25A8%25E4%25B8%2580%25E8%25A1%258C%25E6%2580%258E%25E4%25B9%2588%25E6%2593%258D%25E4%25BD%259C%2526tj%253Dwww_jingyan_normal_1_0_10_l%2526src%253Dhttps%2525253A%2525252F%2525252Fjingyan.baidu.com%2525252Farticle%2525252F154b4631a4b48569cb8f4138.html%2522%257D%26useTpl%3D1