excel 复制日期
发布网友
发布时间：2022-04-23 14:05
共1个回答
热心网友
时间：2022-05-13 06:50
把单元格设置成数值的办法：
1、选中D4单元格到D9单元格的区域。
/iknow-pic.cdn.bcebos.com/d009b3de9c82d158f7790dcc8c0a19d8bd3e42d7?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/d009b3de9c82d158f7790dcc8c0a19d8bd3e42d7?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="excel 复制日期" />
2、找到任务栏开始中，数字里的数字格式。
/iknow-pic.cdn.bcebos.com/ae51f3deb48f8c54b235915236292df5e1fe7fec?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/ae51f3deb48f8c54b235915236292df5e1fe7fec?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="excel 复制日期" />
3、单击数字格式中的其他数字格式。
/iknow-pic.cdn.bcebos.com/472309f790529822a3f46dbedbca7bcb0b46d48c?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/472309f790529822a3f46dbedbca7bcb0b46d48c?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="excel 复制日期" />
4、在设置单元格格式中，点击自定义。
/iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3dab96b34db6a1cd11728b2953?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3dab96b34db6a1cd11728b2953?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="excel 复制日期" />
5、在接下来出现的类型当中，我们会看到一些内置格式中的常规格式，了解到这些格式代码的意义，就可以轻松进行单元格的设置了。
/iknow-pic.cdn.bcebos.com/bba1cd11728b4710e05faab1cfcec3fdfc03235e?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/bba1cd11728b4710e05faab1cfcec3fdfc03235e?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="excel 复制日期" />
