Convert =now() to number

[davidtips]

Pls help!

in cel A1 is =now(), formatted to long date.
How can I convert this date in cell B1 as number??

For example: A1 = 31/Mar/2005, B1 will show "3". If now is 01/Apr/2005, B1 will show "4" and so on with other months.....

thanks!!
davidiew

[Cutter]

In B1 type =MONTH(A1)