This formula doesn't work: = day(today())

[0-0 Wai Wai ^-^]

This formula doesn't work: = day(today())

Except from spreading one formula into 2, is it possible to make it workable in
1 formula?
If so, how?

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

¥»¤Hªº¯à¤O«D±`¦³­­. ¦p¦³¤£·í¤§³B, ±æÃѪ̤£§[½ç¥¿!!
My ability is very limited. Hope you will not mind to enlighten me if I do
wrongly.

 

[JE McGimpsey]

What doesn't work?

For today (7 May 2004)

=DAY(TODAY())

returns 7.

 

[Don Guillett]

I just tested xphome xl2002 (your configuration too) and it worked fine

 

[Otto Moehrbach]

It works for me. Make sure that you format the cell as General after you
enter the formula. HTH Otto

 

[0-0 Wai Wai ^-^]

Thanks for all.
Problems solved.

The reason of not working is:
- after I entered the formula, Excel will help me to change the cell format into
"date". That's the problem.
Is there any way to stop this automatic change?