Cell to return present month

[joromajr]

-- How can I make a cell return present month and remain as such.

Ex. present month is July... A1 will return "July" will have data encoded
in b1. But when august comes it will not change anymore?
joromajr

 

[Peo Sjoblom]

Press ctrl + ;

then format as mmmm

Or use

=TEXT(TODAY(),"mmmm")

then copy and paste special as values in place preferably before 08/01/08
<g>

--


Regards,


Peo Sjoblom

 

[joromajr]

-- Thank you for the quick response, but situation call for a more
permanent solution as the file will be distributed to 72 offices whose
locations are mostly overseas.

Please help need more suggestions.

joromajr

 

[Wigi]

Why shouldn't it work anymore, then?

 

[joromajr]

-- Because it will serve as account database for transactions of particular
month.
joromajr