Randomthots wrote:
>> =CONCATENATE("Today's Date: "; today())
>>
> One possibility: go into Format -> Cells and find the appropriate date
> format. Then put your cursor into the format string box at the bottom
> and add this to the front of it: "Today's Date: "
>
> For example, if you put in the format code:
> "Today's Date: "NNNNMMMM D, YYYY
>
> You get
> Today's Date: Wednesday, December 7, 2005
Other possibility is to use
=CONCATENATE("Today's Date: "; TEXT(today(),"XXX"))
And instead of XXX put the format of date you desire (see help for more).
Matej
--
Matej Cepl, http://www.ceplovi.cz/matej/blog/
GPG Finger: 89EF 4BC6 288A BF43 1BAB 25C3 E09F EF25 D964 84AC
This is a test of the emergency signature system. Were this an
actual signature, you would see amusing mottos, disclaimers,
a zillion net addresses, or edifying philosophical statements.
this is only test.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
