How to add the date after the "A1"

's Computer Specifications

Hi,

I type "The information gathered as of March 9, 2008" on cell "A1"

Is there a way to make a date default like

"The information gathered as of " & Date (default).

Your help would be much apprecated.

's Computer Specifications

="The informations gathered as of "&TEXT(TODAY(),"mmmm d, yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<(E-Mail Removed)> wrote in message news:c11a1bfc-65ba-4cf3-bdef-(E-Mail Removed)...
| Hi,
|
| I type "The information gathered as of March 9, 2008" on cell "A1"
|
| Is there a way to make a date default like
|
| "The information gathered as of " & Date (default).
|
| Your help would be much apprecated.

's Computer Specifications

Another way is to use a custom number format:

Format|Cells|Number tab|Custom category:

"The information gathered as of "mmmm d, yyyy

"(E-Mail Removed)" wrote:
>
> Hi,
>
> I type "The information gathered as of March 9, 2008" on cell "A1"
>
> Is there a way to make a date default like
>
> "The information gathered as of " & Date (default).
>
> Your help would be much apprecated.

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display a "Date" or "Month" or "Year" in a report	Larry	Microsoft Access Reports	2	6th Aug 2008 10:55 PM
How do I save "details" View + "Date Modified" in "insert file"	Kevin Clough	Microsoft Outlook Discussion	1	16th Jun 2008 10:59 PM
Remove "Date: Yesterday" or "Date: Monday" from Outlook Inbox?	=?Utf-8?B?c2lsa3k=?=	Microsoft Outlook	1	16th Jul 2005 04:54 PM
Calulate "Start Date" by subtracting "Duration" from "End Date"	=?Utf-8?B?QnJlbmRhbg==?=	Microsoft Access	1	7th Jun 2005 10:16 PM
"Open" Dialog Box - Sorting by both "type" AND "date modified"	Sam	Microsoft Word Document Management	2	21st Jul 2004 09:53 AM