軟體:excel
版本:2003, 2007
我的儲存格格式設定為yyyy-mm-dd hh:mm:ss
我在儲存格按ctrl+;,再按空白,然後再按ctrl+shift+;
但是在秒數部份都顯示00,請教板友該如何解決?
感謝~~
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.236.66.194
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1473819526.A.8DD.html
→
09/14 12:47, , 1F
09/14 12:47, 1F
→
09/14 12:48, , 2F
09/14 12:48, 2F
→
09/14 12:54, , 3F
09/14 12:54, 3F
→
09/14 12:55, , 4F
09/14 12:55, 4F
→
09/14 13:01, , 5F
09/14 13:01, 5F
→
09/14 13:02, , 6F
09/14 13:02, 6F
→
09/14 13:23, , 7F
09/14 13:23, 7F