可以嘗試將提取出來(lái)的出生年月改成文本格式后再?gòu)?fù)制粘貼

你好，重新打開(kāi)復(fù)制下，有時(shí)復(fù)制過(guò)程程序有問(wèn)題會(huì)出現(xiàn)這種情況的！復(fù)制的粘貼到的位置有沒(méi)篩選

你好，直接復(fù)制過(guò)去，然后用格式刷刷一下就好了。

你好，選擇要復(fù)制的內(nèi)容，可以定位出可見(jiàn)單元格，然后再?gòu)?fù)制粘貼，或者選擇后ALT加； 然后復(fù)制粘貼

你好同學(xué)看看這個(gè)有具體操作過(guò)程！ 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