时间函数在excel 不work ? hello22007-12-04 00: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 ?

It works fine in excel 2007. Check number format in A7, B7

it works in 2003

回复：时间函数在excel 不work ?

谢谢各位，我怀疑是因为locale是中文的缘故