Arjun wrote:
Hi folks,
This probably has a simple solution (I hope).
I am trying to format the date in the following:
=CONCATENATE("Today's Date: "; today())
The problem is that even if format the cell to have date formatting with
whatever format I choose, it has no effect on the result. The result is
still showing the date as "38693" instead of the chosen date format
"December 7, 2005". How can I go about doing this? I suspect I will need
the ability to have control over the format of "substrings" of cells
quite often so this would be very useful information.
Thanks in advance.
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
HTH
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
