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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
