时间函数在excel 不work ?

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 ?

所有跟帖： 

• It works fine in excel 2007. Check number format in A7, B7 -NaCl- ♂ (0 bytes) () 12/03/2007 postreply 18:32:37

• it works in 2003 -jensen- ♀ (0 bytes) () 12/04/2007 postreply 07:54:14

• 回复：时间函数在excel 不work ? -emmmm- ♀ (72 bytes) () 12/04/2007 postreply 08:30:32

• 谢谢各位，我怀疑是因为locale是中文的缘故 -hello2- ♂ (89 bytes) () 12/04/2007 postreply 19:56:52