win10系统excel2019单元格显示完整的年月日时分秒设置方法

ゞ浴缸里的玫瑰 2023-01-11 09:19 184阅读 0赞

# #

## [https://www.pianshen.com/article/88671983757/][https_www.pianshen.com_article_88671983757] ##

# #

## win10系统excel2019单元格显示完整的年月日时分秒设置方法 ##

技术标签： [Windows][]  [excel显示年月日时分秒][excel]  [excel显示完整的详细时间][excel 1]  [excel2019显示完整时间][excel2019]  [excel2019显示具体时间][excel2019 1]  [excel显示具体的时间][excel 2]

描述：win10系统excel2019单元格显示完整的年月日时分秒设置方法  
步骤：

1.  原数据![20210126184924264.png][]
2.   
3.  选中，右键选择设置单元格格式
4.  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI3MzI3MjYx_size_16_color_FFFFFF_t_70][]
5.  选择数字->自定义->类型输入yyyy/m/d h:mm:ss->确定，就显示完整的年月日时分秒  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI3MzI3MjYx_size_16_color_FFFFFF_t_70 1][]

本文链接：[https://blog.csdn.net/lk583998442/article/details/108893210][https_blog.csdn.net_lk583998442_article_details_108893210]

[原作者删帖][Link 1]   [不实内容删帖][Link 2]   [广告或垃圾文章投诉][Link 3]

[https_www.pianshen.com_article_88671983757]: https://www.pianshen.com/article/88671983757/
[Windows]: https://www.pianshen.com/tag/Windows/
[excel]: https://www.pianshen.com/tag/excel%E6%98%BE%E7%A4%BA%E5%B9%B4%E6%9C%88%E6%97%A5%E6%97%B6%E5%88%86%E7%A7%92/
[excel 1]: https://www.pianshen.com/tag/excel%E6%98%BE%E7%A4%BA%E5%AE%8C%E6%95%B4%E7%9A%84%E8%AF%A6%E7%BB%86%E6%97%B6%E9%97%B4/
[excel2019]: https://www.pianshen.com/tag/excel2019%E6%98%BE%E7%A4%BA%E5%AE%8C%E6%95%B4%E6%97%B6%E9%97%B4/
[excel2019 1]: https://www.pianshen.com/tag/excel2019%E6%98%BE%E7%A4%BA%E5%85%B7%E4%BD%93%E6%97%B6%E9%97%B4/
[excel 2]: https://www.pianshen.com/tag/excel%E6%98%BE%E7%A4%BA%E5%85%B7%E4%BD%93%E7%9A%84%E6%97%B6%E9%97%B4/
[20210126184924264.png]: /images/20221119/540ffe4e9df64f359c2819254e88bd0a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI3MzI3MjYx_size_16_color_FFFFFF_t_70]: /images/20221119/c07d574a79d74408ad98a790b56e3833.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI3MzI3MjYx_size_16_color_FFFFFF_t_70 1]: /images/20221119/76fe7d45efbb4bb49ba0de399aadabe4.png
[CC 4.0 BY-SA]: https://creativecommons.org/licenses/by-sa/4.0/
[https_blog.csdn.net_lk583998442_article_details_108893210]: https://blog.csdn.net/lk583998442/article/details/108893210
[Link 1]: https://www.pianshen.com/copyright.html#del
[Link 2]: https://www.pianshen.com/copyright.html#others
[Link 3]: mailto:pianshen@gmx.com?subject=%E6%8A%95%E8%AF%89%E6%9C%AC%E6%96%87%E5%90%AB%E5%B9%BF%E5%91%8A%E6%88%96%E5%9E%83%E5%9C%BE%E4%BF%A1%E6%81%AF%EF%BC%88%E8%AF%B7%E9%99%84%E4%B8%8A%E8%BF%9D%E8%A7%84%E9%93%BE%E6%8E%A5%E5%9C%B0%E5%9D%80%EF%BC%89