How to add the date after the "A1"

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.
0
3/9/2008 3:07:51 PM
excel 39879 articles. 2 followers. Follow

2 Replies
698 Views

Similar Articles

[PageSpeed] 51

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

-- 
Kind regards,

Niek Otten
Microsoft MVP - Excel

<learning_codes@hotmail.com> wrote in message news:c11a1bfc-65ba-4cf3-bdef-c28bdcc19c1d@8g2000hse.googlegroups.com...
| 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. 


0
nicolaus (2022)
3/9/2008 3:26:15 PM
Another way is to use a custom number format:

Format|Cells|Number tab|Custom category:

"The information gathered as of "mmmm d, yyyy



"learning_codes@hotmail.com" 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
0
petersod (12005)
3/9/2008 4:37:17 PM
Reply:

Similar Artilces:

Trigger Event Sub when A1 <> B1
Hi, Let's say I have values in two cells, A1 and B1. A1 contains a fixed value. B1 displays a value from a DDE connection to a communication server that pulls data from a particular device. The value in B1 can change at any time. Under normal circumstances, B1 should always be equal to A1. If B1 changes and is no longer equal to A1, this indicates an alarm condition and I would like this condition to trigger a VBA Sub which will include some code to process the alarm. So far, the only way I think of doing this is by responding to the Worksheet_SelectionChange...

Creating a list of info in A1 cell in multiple worksheets
How can I create a list of the info/contents in the A1 cell in multiple worksheets? I am trying to create a summary worksheet of the data from 90 worksheets and would like to be able to list the headers in the A1 cell vertically. 'Right click on the summary sheet tab, and paste in this macro. 'Edit where appropriate: Sub CreateSummary() 'Starting row for summary: i = 1 For Each Sheet In ThisWorkbook.Sheets If Sheet.Name <> Me.Name Then 'Control What column to place data in Me.Cells(i, "A").Value = Sheet.Range("A1").Value i = i + 1...

If E9 Is red then place tommorrows date in A11
XL-2000 Is there a formula that can If E9 Is red then place tomorrow's date in A11 or If E9 Is green then place tomorrow's date in A11 Allan Is this a typo or did you mean "if E9 is green or red place tomorrow's date in A11"? Perhaps one of the "tomorrows" should be "today". How does E9 get to be green or red? Conditional Formatting? If so, use the same condition in a formula in A11. If you manually format E9 to be green or red, you will have to use VBA to return whichever date in A11. Some more detail maybe? Gord Dibben Excel MVP - XL9...

A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whole column?[/
*A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol column? -- Johnny ----------------------------------------------------------------------- Johnny3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1675 View this thread: http://www.excelforum.com/showthread.php?threadid=31958 Johnny3 Wrote: > *A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol > column?* If I understand your post correctly, enter this formula in Cell B1 =if(A2="","",(A1-A2)/A2) and copy down as required -- BenjieLo ----------------...

How do I rename my columns? (i.e.
Just trying to get specific info at the top of my spreadsheet where (A1, B1, C1....etc) are. Not sure quite how to do it. Any assistance would be appreciated. Thanks in advance. Hi, You cannot rename the columns, you can use the first row to enter your names instead "Novice" wrote: > Just trying to get specific info at the top of my spreadsheet where (A1, B1, > C1....etc) are. Not sure quite how to do it. Any assistance would be > appreciated. Thanks in advance. Use row 1. If the A1, B1, bother you, Tools - Options - View, hide column Headers. -- ...

IF value = 5 then change cell A1 else change B1
Hi guys is it possible for me to change the value of another cell using the IF and else statements??? -- mkwazeeri ------------------------------------------------------------------------ mkwazeeri's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27222 View this thread: http://www.excelforum.com/showthread.php?threadid=467356 No. You'd have to put an IF in A1 and B1. ************ Anne Troy www.OfficeArticles.com "mkwazeeri" <mkwazeeri.1vbqqd_1126659950.5675@excelforum-nospam.com> wrote in message news:mkwazeeri.1vbqqd_1126659950.5675@ex...

how do i mark range from A1 to DV5000 without scrolling?
Hi Is there a menu option to mark a range from A1 to some far off cell like DK4563 without scrolling all the way down and across? thanks Cricket :-) You can type the address, e.g., A1:DK4563, in the Name Box, which is to the left of the formula bar. This will select the specified range. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com <cricketunes@yahoo.com> wrote in message news:1134001998.341982.309400@g47g2000cwa.googlegroups.com... > Hi > Is there a menu option to mark a range from A1 to some far off > cell > l...

Load Excel with focus on A1
I have a spreadsheet containning multiple sheets. I would like to be able to load the spreadsheet and to have all sheets with focus on a1. Is there a code i could put in Myworbook or is there something else I could do to have it automativcally load with focus on A! each time. The reason why is that many people do view the spreadsheet and when it opens I need to be initialize to A1. Thanks Fab -- Fabiolus ------------------------------------------------------------------------ Fabiolus's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28340 View this thread: htt...

how to stop repeating a number in worksheet(e.g. cell A1 is 6655 .
I want to to know I can stop a number to repeat in excel worksheet. (e.g. cell A1 is 6655 so 6655 should not repeat inwhere in the worksheet of even if it appears there could be a pop up massage says number repeated in cell# A1) You can use data validation to prevent duplicates. There are instructions here: http://www.contextures.com/xlDataVal07.html And to include a message, add an error alert or input message: http://www.contextures.com/xlDataVal04.html Mushtaque Parker wrote: > I want to to know I can stop a number to repeat in excel worksheet. (e.g. > cell A1 is 6655 s...

Sorting a1,a2,a10,a11
D'OH! What can be done to have this sort as above as opposed to a1,a10,a11a2. Sincerely, Arturo Only by using a help column that will extract the numbers and sort by that help column ascending -- Regards, Peo Sjoblom "Arturo" <Arturo@discussions.microsoft.com> wrote in message news:A3109BCF-29D6-4C97-9AA3-6F7897E2A24F@microsoft.com... > D'OH! > What can be done to have this sort as above as opposed to a1,a10,a11a2. > > Sincerely, > Arturo ...

Window resets to A1 when entering data
I'm using Excel 2004 for Mac on a MacBook Pro with OS 10.5.8. When I go to enter data into a cell, the window automatically moves so that A1 is the uppermost left cell. This is very frustrating because I then have to find the cell I was entering data into by scrolling all over the place. Any ideas on why the cell I'm entering data into won't stay in view? not sure never seen a mac, but does it only happen in one workbook on one sheet? do you have any code on the code page? -- Gary Keramidas Excel 2003 "Mac User" <Mac User@discussions.micro...

What if I wanted to combine a1 b1 c1 d1
What if I wanted to combine a1 b1 c1 d1? How do I do that -- Message posted from http://www.ExcelForum.com Hi see your other thread. P.S.: please stay in your original thread -- Regards Frank Kabel Frankfurt, Germany > What if I wanted to combine a1 b1 c1 d1? How do I do that? > > > --- > Message posted from http://www.ExcelForum.com/ No need to multipost, Frank has already answered your first post, and you should have been able to use that example and simply expand on it by including C & D in the same manner. It's not going to break it if you try it. :-) ...

IF the date in A1 is a holiday, cell B1 should say "HOLIDAY"
Here's what I want to do but I'm too dumb to it. Usually I Google before asking here but my Internet is down though NGs and email work. PART 1 In cell A1 we enter a date, say, 07/22/04. If the date in A1 is a holiday I want cell B1 to show the word HOLIDAY. If A1 is not a holiday, B1 should be blank. I will list the holiday dates in cells D1 to D10. PART 2 Part 2 is the same as 1 but instead of the word HOLIDAY appearing the name of the holiday, NEWS YEARS DAY, will appear. I will list the holiday names in cells E1 to E10 next to the dates in column D. Hi part 1: =IF(ISNUMBER(MATC...

how to get rid of Comment [A1] in my documents?
In a 300+ document I occasionally get a long "balloon" type thing with "Comment [A1]" (or other number) in it and I cannot get rid of it, nor do I know what it means. HOW do I get rid of it? I use Word 2003. On the reviewing toolbar (View > Toolbars > Reviewing) Show > Balloons > Check 'never'. Or right click the comment balloon and select 'delete comment'. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gm...

Operator precedence (order of operate) =A1/A2*A3^5-(A1+A2)
Hi, what is the order of operating and calculating in this formula? =A1/A2*A3^5-(A1+A2) 1- A1+A2 2- A1/A2 3- A3^5 4- A2*A3 Regards. If it were me, I'd put parens in to ensure I get the calculation I want. "Masood Shahab" <masshahab@hotmail.com> wrote in message news:e9d5QwzsFHA.3928@TK2MSFTNGP15.phx.gbl... > > Hi, > what is the order of operating and calculating in this formula? > =A1/A2*A3^5-(A1+A2) > > 1- A1+A2 > > 2- A1/A2 > > 3- A3^5 > > 4- A2*A3 > > > > Regards. > > > Masood Shahab wrote... &...

Excel help should explain how to change r1c1 to a1
Help describes a1 and r1c1 referencing but doesn't tell how to switch from one to the other. Can anyone help? tools>options>general and uncheck/check R1C1 reference style -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "schlimgen" <schlimgen@discussions.microsoft.com> wrote in message news:D3DD1F56-4181-4EF2-9357-CBE7FD54DF8C@microsoft.com... > Help describes a1 and r1c1 referencing but doesn't tell how to switch from > one to the other. Can anyone help? Click on Tools...

How to fill cells A1, A2, A3... with contents from B1, B4, B7...
Hi, I am trying to copy contents from, say, B1, B4, B7, .... into A1, A2, A3,.... And did not know how to set up a formula to do that. I'd appreicate for any suggestions. Thanks, Xianbo If you're trying to copy every third row from B to A, enter the formula =OFFSET($B$1,ROW()*3-3,0) in A1, and autofill down through the appropriate cells in column A. "Xianbo" wrote: > Hi, > > I am trying to copy contents from, say, B1, B4, B7, .... into A1, A2, > A3,.... And did not know how to set up a formula to do that. I'd appreicate > for any suggestions. &g...

MONTH(a1)
I'VE ACHANGEABLE NUMBER IIN a1 AND I PUT IN b1 "=MONTH(A1) IN ORDER TO GIVE ME THE MONTH'S NAME WHEN I CHANGE THE NUMBER IN A1 BUT IT DDINT WORK WHY? PLZ HELP THANXXXXXXXXXXXXXXXX FOR AL -- frs ----------------------------------------------------------------------- frsm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3123 View this thread: http://www.excelforum.com/showthread.php?threadid=51453 I believe you have to have a date in A1, not just a number. HTH Regards, Howard "frsm" <frsm.23jpcy_1140468300.4445@excelforum-nospam.com...

A1=B1 plus or minus tolerance!HELP ME PLEASE!
hi all! can anyone help me! below is an example of what i am trying to achieve but cannot find th correct formula to do it. in cell (a1) the number 2470.56 in cell (b2) the number 2471.32 i know there is the formula (a1=b2)would give you a true/false answer. but what i am after is for the a1=b2 to have a plus or minus toleranc of say 2 points or the number 2. so that the above numbers in cells a1 and b2 WILL EQUAL each other an give a TRUE answer rather than a FALSE answer. obviously if the numbers were more than 2 points apart then the answe WILL BE FALSE. can anyone help me it would be gre...

How can I use Schedule + Priority in the New To-Do Bar eg A1 A2
I have used the field Schedule + Priority in the older version of Outlook in the Calendar Task Pad and found thsi a very quick way of adding a task with a Priority A1 A2 A3 etc. How can I do this or achieve the same result ...

=?Utf-8?Q?Can_someone_tell_me_what_=22=C3=A1=22__me?= =?Utf-8?Q?ans?=
I get it when I concantenate cells made of text strings please tell us what is in each cell prior to concatenation -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28504 View this thread: http://www.excelforum.com/showthread.php?threadid=497873 Bob the strings are just text "bob777" wrote: > > please tell us what is in each cell prior to concatenation > > > -- > bob777 > -------------------------------------------------------------...

Concatenate A1, B1, and C1 into D1
I have data in Column A1, B1, and C1. I’d like to concatenate all three cells into one sentence in cell D1. Does anyone have code that can do that? Hi, I'm guessing here that it's not just A1, b1 & C1 you want but if you do why not this in d1 =a1&b1&c1 If it's a column of data then try this Sub marine() Dim lastrow As Long Dim C As Range Set sht = Sheets("Sheet1") 'Change to suit lastrow = sht.Cells(Cells.Rows.Count, "A").End(xlUp).Row Set MyRange = sht.Range("A1:A" & lastrow) For Each C In MyRange C.Offse...

REPLACE RANGE("A1:E20") with variable
I did a macro record building a chart and got this piece of code... .. .. ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Line - Column" ActiveChart.SetSourceData Source:=Sheets ("prodcpu").Range("A1:E20"), PlotBy _ :=xlColumns ActiveChart.Location Where:=xlLocationAsNewSheet .. .. I can't use this as a permanent macro because the E20 might be E57(different number of entries) next week. The A1 will always be the start cell.. NEED CODING TO REPLACE A1:E20 as some variable Thanks. There are a number of possibilities: Shee...

All cell contents within a range of cells turns white if Sheet1!A1 = 1
If the return of Sheet1!A1 = 1, I need all fill, font and line colors to turn white from A1:E10. If the value of Sheet1!A1 changes to 0, all colors must return to normal. Does anyone have any thoughts on this? Thanks for any suggestions. Michael If your range to format is on Sheet1............. Conditional Formatting Select A1:E10 Format>CF>Formula is: =$A$1=1 Format to suit If range to format is on a sheet other than Sheet1 Select Sheet1!A1 and give it a name..............insert>name>define On other sheet select range A1:E10 and Format>CF Form...

logical (if a1=specific word, can c1 = value entered in a2?)
I am trying to make a payroll sheet so that if someone enters the word "Stat" into field a1, and then manually enters the number of hours worked into a2, then c1 automatically displays the same value that a2 displays. (I have 2 different columns at the end, one for regular hours and one for stat hours, and I need them to display all of the regular hours into one field and all of the stat hours into the column beside it.) =IF(C1="Stat",A2,"") "mel" wrote: > I am trying to make a payroll sheet so that if someone enters the word "...