how to convert
1:00:03 to 010003
前者是時間格式, 後者是要文字格式.
excel: time value to text value
2008-06-06 6:35 pm
回答 (1)
2008-06-06 7:16 pm
✔ 最佳答案
Example:In A1, type 1:00:03
In B1, type =text(A1, "hhmmss"), Enter, and you get 010003
收錄日期: 2021-04-13 15:39:31
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080606000051KK00627