Time Scale Default
Every time I set the time scale to 30 minutes, after I close Outlook and
reopen it, it reverts back to to th 60 minute time scale. How do I stop it
from doing this?
Signing off ror now,
Make sure that Outlook is actually closing properly as there are add-ins
that will interfere with the save. Look in Task Manager Processes to see
that Outlook.EXE actually stops and disappears.
Bill G wrote:
> Every time I set the time scale to 30 minutes, after I close Outlook and
> reopen it, it reverts back to to th 60 minute time scale. How do I stop it
> from doin...Cannot change line/object color in Publisher 2002
Anyone who can help:
I'm using an older version of Publisher (2002). I was working on a floor
plan for a project when suddenly, all the lines and borders disappeared. I
am now unable to make any selection to change the line color--the selection
defaults to a blank option no matter what color I choose, creating
essentially invisible objects and lines in my files, even new ones.
I uninstalled and reinstalled Publisher twice to no effect--the problem
persists. (Interestingly, the same files when opened in Publisher 2002 on
another machine display fine.)
Is there something else that co...Change line to bar in Line
Hope someone can help on this one...I have 4 data series that I am trying to
plot on a Line-Column chart. I need 3 of these to be columns and one to be a
line. It is defaulting to 2 columns and 2 lines.
Does anyone know how to override that default, so I can change the one line
(basically the 3rd data series) to a column?
Select the series you want to change, then on the Chart menu, choose Chart
Type, and choose the new type to assign to that series.
Next time, starting from scratch, make a column chart with all four series,
then change the one to a line.
Jo...25 changes to 35
When the value of 25 is entered into a cell, the screen returns the value of
I have scanned for viruses, tracking software, defalt setup values,
uninstalled an reinstalled excell, updated, etc. Still I get a value of 35
when I enter 25.
Check Tools>AutoCorrect Options and see if someone is playing a trick on
"David Sound Tech" <David Sound Tech@discussions.microsoft.com> wrote in
> When the value of 25 is entered into a cell, the screen returns the value
&...Reports by date
I'm trying to get reports based on a user input date. I don't want all the
in the database just the entries from a certain date and newer.
Could someone please help?
...Changing Depre Life
I have a number of fixed assets that I need to extend the life. Their in
service date was in the prior fiscal year. If I go to the Asset Book screen
& change the life, <save> the screen & choose "Year" as the reset option (not
Life or Recalculate), shouldn't I get some financial entries reflecting the
current year adjustment of depreciation?
I tried it in the test company & I'm not getting any GL entries. Any help
You have to run the GL Posting Routine at Tools>Routines>Fixed Assets
to generate the GL entry.
Fr...About worksheet change event.
I wrote a code and somewhere, I want to restrict any changes with multiple
cell selections, "except" adding a whole row by right-clicking on the row
number bar. How can i do this?
Maybe you could test like this
If Target.Rows.Count = 1 And Target.Count = Rows.Count Then
(remove nothere from the email address if mailing direct)
"serdar" <email@example.com> wrote in message
> I wrote a code and somewhere, I want to restrict any changes with multiple
> cell selections, "except"...active directory, exchange, crm
I am trying to figure out the best way to allocate to minimal amount of
hardware the following components: active directory, exchange, crm (1+
installations), virtual server, etc.
if I had only 2 actual servers, which one should have active directory,
exchange, sql server, crm, virtual servers, etc.Should all CRM
instances go onto virtual servers?
should I use redundant disk on both servers?
Also what is the best approach for windows updates in production
environment? could they cause problems, crashes, etc.? I recently had a
bugcheck x50 when tried running the security updates that were in...Change the default Calendar
Hej to all
I have outlook 2010 with 2 calendars, calendar and work. By default the
default calendar is calendar, but I would like to be work, since calendar
have almost my private things, there is a way to change the default calendar
Thanks to all.
No, you'll have to copy over the items from one to the other.
Personally I don't use 2 calendars for this but use a single calendar and
categorize my appointments accordingly.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft...Critique a function to convert time, please
I have a bunch of data representing time intervals that come from a
database application. The intervals vary from a few seconds to several
years. The database (MySQL) stores time intervals as fixed point
numbers in units of seconds.
Reading the values in seconds is unnatural (a year is ~31.5E6
seconds), so I wrote a little UDF to convert the seconds to more
natural units. The conversion is:
<60 seconds Seconds
<60 minutes Minutes
<24 hours Hours
<99 days Days
I chose 99 days as the threshold betwe...Budget dates
Is it possible to customize the dates in the budget, instead of having
calender months? e.g. 010106 to 020606
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
> Is it possible to customize the dates in the budget, instead of having
> calender months? e.g. 010106 to 020606
...Text cell complains about date
I have a column containing ratios like 3/4, 3/0, 5/2, etc.
I have them all formatted as text.
All of the cells that have a zero as the second number (3/0) get a
little green triangle and a warning that I have entered a "date string
with only 2 digits for the year".
How is "3/0" a date string with 2 digits for the year?
And, why is it complaining about a text field?
More importantly, how do I get Excel to stop being so "helpful" and
leave my damned text data alone -- unexamined?
Remove the warning in Options, Tools>Options>Error Checking in 2003...How do i get excel to add a range of times & display as total as .
I'm trying to get excel to add a range of times together and display the
total as the sum of all of these hours. I can enter the times but keep
getting the strangest of totals. Any help please.
Use a custom format [hh]:mm for example otherwise it will always start over
after 24 hours so 30:00 shows as 06:00, later if you need to apply a pay rate
note that you have to convert to decimals by multiplying with 24, i.e.
> I'm trying to get excel to add a range of times together and display the
> ...using the time structure with MFC
Coming from C, how could I translate this into MFC based code (using
char szTime, szDate;
time_t t = time(0);
struct tm* tm = localtime(&t);
strftime(szDate, 64, "%Y%m%d", tm);
strftime(szTime, 64, "%H%M%S", tm);
CString strTime, strDate;
CTime Time = CTime::GetCurrentTime();
CString strDate = Time.Format("%Y%m%d");
CString strTime = Time.Format("%H%M%S");
"markww" <firstname.lastname@example.org> wrote in message
news:1156883820.948360.39250@m79g200...Change the name of an auto save
I am trying to write a macro that will save the file to a specific cell
reference. The reference is a specific name that is automatically generated
by another macro function.
Any suggestions on how I could do this?
IS thsi what you want?
sFilename = Format(Worksheets("Sheet1").Range("A1").Value)
ans = MsgBox("Save file as " & sFilename)
If ans = vbOK Then
If this information was helpful, please indicate this by clicking ''Y...Date Logging via Workflow
It's not enough in my company to simply know what Sales Stage a given
Opportunity is in, but what date the new stage began. We not only need to
know how long the Sales Cycle took, but how long between Stages. Please allow
for Workflow date logging with Sales Stages. Better yet, Please allow for
Workflow to update date flields.
Even better, allow work flow to trigger JScript.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message...Auto date changing in Excel is maddening
I'm using MS Office Excel 2003 (11.6113.5703) to post data that spans over
or try http://tinyurl.com/6f8zn
We had to jump through all kinds of work-arounds in order to accomplish
this. It was not a straight-forward process, though it should have been.
When I enter the date format, for example, as
Format > Time > 3/14/01 13:30
And then enter 11/17/04 0:30:30, it enters okay, but when I double click on
the cell to edit it, Ex...How do I change the color of tabs in word 2008 notebook layout?
I've been trying to figure out how to change the color of the section tabs with no success. Does anyone know how to do this?
In article <email@example.comR9absDaxw>,
> I've been trying to figure out how to change the color of the section tabs
> with no success. Does anyone know how to do this?
Right- or ctrl-click the tab and choose a color from the Section Color
I'm looking for the same thing; in addition - how to delete extra tabs.
Ctrl-/right-click a tab, and you can change its colour as well as delete the
tab (a...changing the scale from hours to days in the Resource Usage view
My current Resource Usage view shows my resources and the hours allocated for
each resource in hours. How can I change this view so that it tells me the
allocated effort for each resource in days, as opposed to hours?
thanks in advance.
Tools > Options > Schedule > Work is Entered In....
- Andrew Lavinsky
> My current Resource Usage view shows my resources and the hours
> allocated for each resource in hours. How can I change this view so
> that it tells me the allocated effort for each resource in days, as
> ...change cells contents from vertical to horizontal
I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?
Select the data to be copied>Copy>Select target cell>Right
If this post helps click Yes
> I need to copy from one workseet the values in cells that are arranged
> vertically into another worksheet and the values need to be arranged
> horizontally. Can this be done? ...adding times
please help, i need to add times greater than 9999:59 on my laptop
running xp on a spreadsheet
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Times in XL are stored as Fractional days (i.e., 03:00 = 0.125). So
you can continue to add times >9999:59, but you can't display them
in time format. You can get a decimal format by multiplying by 24,
A3: =(A1 + A2) * 24 ===> 10001.25
Or you could display the colon forma...long datatype to date string
In my cell I have a long datatype value, like 1046101500. Now I want to have
this converted to a
date string like 'dd/m'/yyyy hh:mm:ss', so my example would be converted to
Is this possible?
How does your data type correspond to the date? Where is the year? Month?
"Candy" <andy_hilvenNOSPAMPLEASE@hotmail.com> wrote in message
> In my cell I have a long datatype value, like 1046101500. Now I want to
> this converted to...Time Calculation Q
I have the following formula that is not producing the correct result for me
It is formatted as [h]:mm
In my instance E16 is greater than 6 but less than 7.9999999, so the result
should be 0.5, which when formatted as [h]:mm should produce 0:30.
My answer returns 0
E16 is also formatted as [h]:mm and returns a value of 7:05 which is = to
Where am I going wrong?
Does this answer your question:
Key into A1,
In B1...Unable to change Send From account in OL2K
I have just changed my Outlook 2k configuartion due to obtaining an account
on an exchange server. I have numerous account sand in the past was able to
determin ewhich account an email was sent from at the time I send it. I now
cannot see any optoin to do that on the send button. Any help on this?
"Mike Cook" <firstname.lastname@example.org> wrote in message
> I have just changed my Outlook 2k configuartion due to obtaining an
> on an exchange server. I have numerous account sand in the past was able
> d...x-axis dates
I have set up my line chart in 2007 with dynamic paramaters (names) and since
then the date catagory is controlled by horizontal(values). The axis values
are numbers even though the labels appear as dates. I have to use the
microsoft numbers to determine the axis start and end limits. What happened?
Perhaps I can better explain my problem. When I select the x-axis to
reformat instructions are that I should be able to change axis type. That
assumes I have horizontal (catagories) listed. I have horizontal(values) and
there is no type to change.