Free Trial Issue
Hello, I just downloaded the Publisher 2007 free trial, recieved the email
with the trial key, and was able to open the program. However, when I try to
start a New project nothing will open...I keep getting the response '
Publisher cannot complete the operation'. What can I be doing wrong?
Did you activate the trial?
Do you have a default printer selected?
Try opening Publisher as the administrator.
"michele411" <firstname.lastname@example.org> wrote in message
news:BCE8D514-B734-4E0C-929C-A6D4BB32D813@micros...strange date format problem
I downloaded some data on excel using Bloomberg. One column has dates
and the other has numbers. Dates appear as 01/01/1980 format which I
want in Jan-80 format. I have changed the format cell properties but it
still appears as 01/01/1980. I have to goto individual cell and press
F2 <enter> so see the effect. Dont know why? I cant even copy paste
format after that ....
I am not sure, but is your workbook set to Auto-Recalculate?
Try pushing <F9> to do a manual re-calculation, see if that changes the
formats. If it does, go to Tools (on the menu bar), Options,
Ca...How to sort by name then date?
I would like to look through all the emails to a particular person. If I
click on the "To" column I can see all the emails to a particular person
(actually there is a problem with that which I will mention next) but they
seem to be in random order. Is there a way to have them sorted by date?
(i.e. by name first, then by date).
Actually, sorting on the "To" column does not get all the emails sent to a
given email address. Because Outlook uses the "display as" field. It will
often give different "display as" names to the same email address. C...Code 19 with Amex issued by Costco
I get an error : Code 19 when I swipe American Express cards that are issued
by Costco. All others swipe fine. I can manually type the Costco cards, and
they approve. Anyone else been down this road before ? Thanks for any help.
This is a multi-part message in MIME format.
Check with your processor as the Costco card and others have a special =
discount rate (higher) attached to them and you may not be able to =
Jef...Concatenate including a date so that the date appears as a date
When I try to join the contents of several cells, one of which is a date and
time obtained from =now(), the date and time part appears as a number. How
can I make it appear as a date and time? I have tried changing the cell
formats - probably there is a combination that works but I haven't found it.
I also tried copying the original date cell to another cell and changing the
latter cell's format and concatenating using that latter cell, but still no
Use the TEXT function. For example, =TEXT(NOW(),"mmmm d, yyyy") would give
January 6, 2010
"dd...printing error handling issue? (when clicking cancel get 2501 error)
I have a report that when it is closed the
DoCmd RunCommand acCmdPrint occurs ... but of course if the user clicks
cancel, it gives me
a 2501 error.
How & where do I put code to surpress this error. I would just the close
even to run the
DoCmd RunCommand acCmdPrint and if cancel is selected just continue to close
I understand that I have to do this, I actually don't understand HOW to do
it, and where to put code to accomplish this??
1) What code do I use?
2) Where do I put the code?
"Duane Hookom" <duanehookom@NO_...if statement with dates #2
I would like to have a statement like:
with 1/1/2004 beint a date.
EXCEL is interpreting 1/1/2004 as an arithmetic statement and giving me the
result of the arithemtic.
I could put in the numeric offste for the date and write
IF(a1>0,37987), formatting the cell as a date, but this seems awkward.
What else can I do?
...Count Unique Cells, within a date range (dates stored in separate column).
I am attempting to create a formula that will count the number of
unique cells (alpha-numeric) in an entire column (no set length, so
ex: "$B:$B"). This count will be based on a date range (Between 2
dates). The dates are stored in another column (Ex: "$A:$A"). The
following is an example of the cells.
I would like to know a formula that can count the number of different
PO's based on a given date range.
Please help me if you...Counting Dates?
=COUNTIF(A1:A100,"<" & NOW())
This works good for specific cells. I have a similar question.
How would I do the same thing given that:
1) You only have a starting date
2) Your only wanting to count work days (in this case 4 day/wk) up to NOW()
Thank you for all your help.
On Thu, 6 Jan 2005 12:53:03 -0800, "Aviator"
>=COUNTIF(A1:A100,"<" & NOW())
>This works good for specific cells. I have a similar question.
>How would I do the same thing given that:
>1) You only ha...An expression for dates from and to
I am trying to create an expression to select items from a date field falling
from a certain date to a certain date. I am obviously missing something in
my expression. The field name is DateComplete. How can I set up this
expression to pull date from a certain date to a certain date?
An example of the SQL would be:
FROM [TABLE NAME]
WHERE DateComplete Between #1/1/2006# And #1/1/2007#
On May 23, 3:52 pm, Ronnie <Ron...@discussions.microsoft.com> wrote:
> I am trying to create an expression to select items from a date field falling
> from a...Returning only MAX(date) not all dates
I want to be able to list the most current date an item is checked out. As I
was working through the query I used max as an aggregate function but I still
can't get the simple result I want. I'd rather list the fields I have chosen
and somehow select just the most current checkout date. Any help would be
greatly appreciated. Here is my query:
SELECT tblTerritory.TerritoryID, [TerritoryName] & " " &
[TerritoryDescription] AS Description, tblTerritory.TerritoryTypeID,
tblTerritoryType.TerritoryType, Max(tblTerritoryCheckout.DateCheckedOut) AS
Does anyone happen to have the hotfix for Exchange2k3 referred to in the
above KB article?
I just dropped a note to MS to see about getting the hotfix sent to me, but
I really need to get the problem taken care of ASAP and it'd be much quicker
to just be able to download it/get it sent to me from somewhere.
This is in reference to the fact that there's no non-3rd party method of
getting non-MAPI email sent to public folders to display as ipm.note rather
Call MS - tell them you are having the exact problem listed in that KB.
They will email ...System Date
Can anyone help me on how to force the system date to a member field of
"Date" type? I could not find any help on msdn that comes with visual c++.
Any hint or help will be appreciated.
Are you just trying to get the current date. You can use
CTime::GetCurrentTime() or COleDateTime::GetCurrentTime()
"Behrouzk" <Behrouzk@discussions.microsoft.com> wrote in message
> Can anyone help me on how to force the system date to a member field of
> "Date" type? I could not fi...Conditional Formatting
I have a spreadsheet that is for tracking work. I would like to have
conditional formatting so that if the date in column E is between todays date
and 4 weeks away then make it blue, if it is a date that is after 4 weeks
away then make it yellow but if it is in the past make it red.
Can this be done with conditional formatting or does it need vba? Also it
would be nice if the whole row changes colour even if just the condition is
on the date which is in column E - but if that can't be done then just the
cell is fine.
Assume the dates start in E2, select all dates w...Time and date problem
I have spreadsheet cell (B1) that contains a date and time:
I have another series of cells (A1 to A100) that contain an increment of 30
I would like to add the seconds to the date and time putting the result in
column C, I have tried to do:
=B1+(A1/100000) but the answer is wrong by 4 seconds and then gets worse the
further down the column I go.
Can somebody show me how to add the seconds to the date please.
Right method, wrong divider! 86,400 secs in a day.. change
your 100000 to 86400 and you're there.
Nikos Y. (nyannaco ...Date subtraction -How to not show negative when 2nd date not entered
Hi, I have a section of a worksheet that just needs to show working days
between two dates.
For example, an order was entered on 9/2/07 and complete on 9/15/07
The formula =NETWORKDAYS(A1, A9) works perfectly except that until the
"completed date" ise filled in, a negative number appears.
Is there a way to have that remain blank until both dates have been entered?
change your formula as
If you think my answer is useful, please rate this post as an ANSWER...Automatically send email based on date value
Is there way to send an email automatically based on a date field in a
table? Some more information about what I am trying to do. I have a
form where users enter in upcoming bids. I would like to send a
reminder email out some specified time (ie, 14 days, 7 days, and again
3 days) prior to the bid being due based on the Bid due date field in
the table. I don't want to have to go into the form and hit a button,
I would just want it to review the table perhaps every time the
database is open or even when the form is opened and send the email.
The email only needs to go to one person, so ...enter days and dates
I've used Fill handle to add all the dates of 2009 in cloumn A.
1) How do I enter all the days (Mon, Tue, etc) in Column B based on
2) What to do if I want only the weekdays in column A?
Thanks for the help,
1) =A1, format as ddd
2) format as ddd
Microsoft MVP - Excel
"cpliu" <email@example.com> wrote in message
> I've used Fill handle to add all the dates of 2009 in cloumn A.
> 1) How do I enter all the days (Mon, Tue, etc) in Column B based...Dates in cells #2
When I start a spreadsheet my first step is to format the columns and
the date format is selected.
Occasionally when entering dates they do not follow the format for that
column or other dates in that column.
Am I doing something wrong?
Anyone else have this problem.
Ralphael, the OLD one
You may want to create an excel template for your date format.
Just type this on the cell "=NOW( )" format the cell you prefer.
> When I start a spreadsheet my first step is to format the columns and
> the date format is selected.
> Occasiona...Excel issue saving files to hexadecimal filenames on terminal server...
I have a customer who has an issue with Excel. He has people connecting to
a terminal server where the spreadsheets and excel is installed and they
open the sheet, make changes, and then save/close the sheet. The issue is
that sometimes the saved sheet ends up with an 8 digit hexadecimal filename.
The users do not get an error and we don't see anything in an eventlog. Any
We read something about excel and the way it saves files. First to the hex
name, then it deletes the original file, then it renames the hex name to the
normal name. I have to assume something is m...My stock transaction date is off 1 day
I just installed the trial version of MSMoney 2004. I downloaded my
data from my broker, but almost all the transaction dates in MSM are
listed in the Capital Gains Report as the day before the actual
transaction. I say almost all, because some are correct.
I also bought and installed Quicken (i'm gonna return it though) and
it has all the dates listed correctly.
Any idea how i can fix this??
Please insert an E between the n & t, to reply via email.
In microsoft.public.money, rondi wrote:
>I just installed the trial version of MSMoney 2004. I downloaded my
>dat...Automatic date entry upon cell completion
I have been unable to figure out how to have the current date
automatically inputted when another cell is completed. For example,
when an employee types his initials in B4, I would like the current
date to appear automatically in C4. Is this possible, and if so, what
is the best way to achieve this?
Message posted from http://www.ExcelForum.com/
This requires a worksheet_change event macro. Right-click
on the worksheet tab, View Code, and paste this in:
Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("B4")) Is Nothing ...Finding Dates in a date range
I have a column in a spreadsheet that consists of dates in dd/mm/yyyy format.
I'm trying to write a formula that looks at the dates by row in the colum
and if the date falls within a certain range (eg from 01/04/2004 to
01/06/2004) then I want to sum the values in another column. I've worked out
that I need to use the sumif function but I can't work out how to analyse the
How do I tell the function to look at the dates in the column and if they
are within a certain range to sum the values in another column. As I said,
I'm pretty sure I need to use the sum...Simple Date Display Question
This is a simple question I think. I have an Excel worksheet that is
displaying dates in the Excel standard date format (five digit number).
However, when I click on a cell, the date is displayed in m/d/yyyy format in
the formula bar. How do I get Excel to display it that way in the
Note that the cells are formatted as date, with mm/dd/yy selected.
You could always try just formatting the cell as text and then enter the date
as mm/dd/yyyy. Or maybe I am not getting what you are asking.
> This is a simp...Date formatting problem #5
I've tried everything I can think of with this one - help!!
I'm reading dates from 2 cells, storing them in variables, comparing them
and then storing the resulting date in a different cell.
Code currently is:
If stStoredDate<> stDate then
Activecell.Offset(0,1).Value = stStoredDate
My problem is stStoredDate = 04/09/05 (4 Sep 05 as I'm in the UK), stDate is
the same, but the value in the cell is 09/04/05 (9 Apr 05). Both cells have
identical formatting. If I change the formatting to 'general', stStoredDate=
38599, but t...