如:
2007/7/10
有人說 Ctrl + ;
不行. 點輪入?
更新1:
如 Ctrl + ; 可以有沒有其它因數我不可以? (Excel 2007, 用Laptop)
更新2:
!! 發現了 !! 我在用倉頡時不可用 Ctrl + ; 但是如轉輪入去EN (英文)就沒問題了. 多謝大家的時間.
Excel 2007 中, 如想輪入今天日期. 有人說 Ctrl + ; 不行. 點輪入?
回答 (2)
2007-11-03 5:44 am
✔ 最佳答案
In Excel 2007, if you type in CTRL+ ; OR CTRL + ' then press ENTER
you will see current date in the cell
If you type =today(), you will also see today's date (2007/11/2). However, if you put that formula in your cell and reopen your excel file next week on 2007/11/9, you will see 2007/11/9 instead of 2007/11/2 in the spreadsheet.
I hope that helps.
收錄日期: 2021-05-03 04:13:02
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071102000051KK03063