复制的时候粘贴的数据格式为什么变了?
发布网友
发布时间:2024-09-15 08:10
我来回答
共1个回答
热心网友
时间:2024-09-23 21:15
是因为另一个表格中的单元格格式不同,所以复制过去的数据显示就会不同。修复操作如下:
一、点击选中日期所在的单元格。
/iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f75a01ea7ff1f3a292cf578fa"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f75a01ea7ff1f3a292cf578fa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f75a01ea7ff1f3a292cf578fa"/>
二、点击Excel2003【格式】菜单中的【单元格】选项。
/iknow-pic.cdn.bcebos.com/91529822720e0cf371f7f0820546f21fbe09aa43"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/91529822720e0cf371f7f0820546f21fbe09aa43?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/91529822720e0cf371f7f0820546f21fbe09aa43"/>
三、点击数字选项卡左侧的【日期】。
/iknow-pic.cdn.bcebos.com/8435e5dde71190ef87632da6c11b9d16fdfa602b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8435e5dde71190ef87632da6c11b9d16fdfa602b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/8435e5dde71190ef87632da6c11b9d16fdfa602b"/>
四、在右侧的类型列表中点选一个要设置的日期类型。
/iknow-pic.cdn.bcebos.com/f603918fa0ec08fac6caacde56ee3d6d54fbda85"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f603918fa0ec08fac6caacde56ee3d6d54fbda85?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fac6caacde56ee3d6d54fbda85"/>
五、点击【确定】后返回页面,就正常显示日期了。
/iknow-pic.cdn.bcebos.com/aec379310a55b319893d3d0c4ca98226cefc1786"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/aec379310a55b319893d3d0c4ca98226cefc1786?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/aec379310a55b319893d3d0c4ca98226cefc1786"/>
热心网友
时间:2024-10-11 08:30
是因为另一个表格中的单元格格式不同,所以复制过去的数据显示就会不同。修复操作如下:
一、点击选中日期所在的单元格。
/iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f75a01ea7ff1f3a292cf578fa"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f75a01ea7ff1f3a292cf578fa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f75a01ea7ff1f3a292cf578fa"/>
二、点击Excel2003【格式】菜单中的【单元格】选项。
/iknow-pic.cdn.bcebos.com/91529822720e0cf371f7f0820546f21fbe09aa43"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/91529822720e0cf371f7f0820546f21fbe09aa43?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/91529822720e0cf371f7f0820546f21fbe09aa43"/>
三、点击数字选项卡左侧的【日期】。
/iknow-pic.cdn.bcebos.com/8435e5dde71190ef87632da6c11b9d16fdfa602b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8435e5dde71190ef87632da6c11b9d16fdfa602b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/8435e5dde71190ef87632da6c11b9d16fdfa602b"/>
四、在右侧的类型列表中点选一个要设置的日期类型。
/iknow-pic.cdn.bcebos.com/f603918fa0ec08fac6caacde56ee3d6d54fbda85"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f603918fa0ec08fac6caacde56ee3d6d54fbda85?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fac6caacde56ee3d6d54fbda85"/>
五、点击【确定】后返回页面,就正常显示日期了。
/iknow-pic.cdn.bcebos.com/aec379310a55b319893d3d0c4ca98226cefc1786"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/aec379310a55b319893d3d0c4ca98226cefc1786?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/aec379310a55b319893d3d0c4ca98226cefc1786"/>