Hi Houm

sorry wasn't thinking
=TEXT(NOW(),"mmmm")
is all you need

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Houm" wrote in message
...
Thanks. But how come it show as January instead of the
current month as April.
-----Original Message-----
Hi

=TEXT(MONTH(NOW()),"mmmm")

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Houm" wrote in message
...

-----Original Message-----

"Houm" wrote in message
. ..
Hi,
I would like to creat a functions that one of the
cell automatic fill as current month. Example the
foramt
as " January " and other cell auto fill with current
year?
what function should I use?

Any help would be very appreciated.



=YEAR(NOW())
=MONTH(NOW())

/Fredrik

Thanks for the answer. But hwo can I use the Format
function to show as month of April instead of show as
number 4?



.



.