時間函數在excel 不work ?

來源: 2007-12-03 16:15:10 [博客] [舊帖] [給我悄悄話] 本文已被閱讀:

if my cell A7 says "01/01/2007"

i put "=MONTH(A7)" in B7,

B7 just display sth. (forgot it),
but not 01

any idea how to solve this ?