Change entries in popup list for partially typed email addresses
When I start a new email and type in the first few letters of a
recipient name or email address, I am given a helpful list of
candidate addresses. However, the email addresses of one acquaintance
in this list needs to be corrected. How can I do this? I tried
looking in the address book, but none of the lists seem to contain
I am using Outlook 2003 on Windows XP.
The autocompletion cache has nothing to do with your Contacts. It is simply
a cache of your prior recipients.
Remove individual addresses from the autocompletion cache by highlighting
the entry when pres...pivot table #6
I have been tasked with putting together a pivot table for my group that will
highlight if a persons vacation falls within blackout dates. Right now I have
a list of names and a start and end date for there vacations. I also have a
list of blackout dates set up with start and end dates. Not sure about where
to start or if this can be done? Below is what I have so far
A B C
1 John Doe 10/1/08 10/8/08
2 Jane Doe 1/2/08 1/9/08
A B C
1 blackout A 1/7/08 1/20/08
2 blackout B 9/28/08 ...How do I make into a dollar format when in a formula?
"We have been asked to contact you by our client 0, regarding your
past due invoice for 7896.98. Their records indicate that payment has
not been received as of the date of this correspondence, and is therefore
listed for collection. This balance may include finance charges. "
How do I make the 7897.98 w/ a dollar amount? The current formula is " & c8
> How do I make the 7897.98 w/ a dollar amount? The current formula is " &
> & ".
Ed Ferrero...Data analysis by 2-dimensional data table + database
in an old Excel-manual (possibly way back to version 3) by Microsoft there
was an excellent example of a 2-dimensional datatable (in German:
Mehrfachoperation) with input variables based on database results. Now I
would need to apply this technique, but my old manual is lost, and I can't
figure out by heart exactly how this was done.
Does somebody still have an old manual from which to draw the model, or can
let me know the deatils of the trick?
Thank you in advance.
I think that you are talking about a cross-tab table....i need to format a column as microseconds ? how do i do this
i need to format a column as microseconds ? how do i do this
eg : hh:mm:ss.___
In the Type box, enter
Microsoft MVP - Excel
"SMT" <SMT@discussions.microsoft.com> wrote in message
>i need to format a column as microseconds ? how do i do this
> eg : hh:mm:ss.___
...changing tcp port used by exchange 5.5?
We are trying to find out if it is possible to change the tcp port that
exchange 5.5 uses to send outgoing (internet bound) emails?
specifically, we are trying to have our internal exchange 5.5 server send
all outbound emails to our unix based/postfix server using a port other then
I have search both technet and google but seem to only find articles
relating to inbound or client based issues.
can you point me in the right direction/tech article?
I have to admit I don't know if this applies to 5.5, but maybe it'll help if
it's somewhat similar. This is how it'...how to change range for dynamic chart in excel 2000 with button?
i need a help please.
i have problem in excel chart. i add data to the table.
and then if i want to update my chart i need to change the range too, isn't
is there any solution for that? i've already use dynamic chart. but it always
show data from Jan04 till Jan05. If I add Feb05 it will change from Feb04 to
what about if i want to see Dec03 till Dec04? is there any command or
something else like using macro or vb? thank you in advance..
You should be able to set the dynamic chart to show just about any range you
want. These articles should help:
http://pu...Changing English text to Spanish text
Hello can anyone help me out with this... I'm creating a
newsletter, and want to see if there is a way to convert
the english text to spanish... Any help would be great..
There are translation services available for a cost.
"Gilbert Saenz" <email@example.com> wrote in message
> Hello can anyone help me out with this... I'm creating a
> newsletter, and want to see if there is a way to convert
> the english text to spanish... Any help would be great.....Excel Formatting #3
I want to know how to format rows into even columns. For
example, my spreadsheet has 160 rows that I would like to
format into 3 even columns across a landscape page. Can
anyone tell me how this is done?
How do I change font colour in a footer??
There are options to change the font, size, underline etc
but not colour... Can anyone help?
You can't change the font colour in a footer. If you really need
coloured text, you could print just the footer using Word, then print
the Excel file onto those pages.
Or, if you have Excel 2002, you can insert a coloured picture into the
footer, so you could create a graphic with the text, and insert that.
> How do I change font colour in a footer??
> There are options to change the font, size, underline etc
> but not...Format for 1st and 3rd Tuesday of each month?
I have a cell that takes todays date from A1, subtracts A2 to end up on a new date, but I need the new date to be the first or third
Tuesday of a month.
And, it needs to round it to the Tuesday that is not past the true sum date, i.e., higher.
TODAYS DATE = 5/26/04
A2 = 10
That would equal 5/16/04, a Sunday.
Though it is closer to Tuesday the 18th, I need it to round to Tuesday the 4th.
try the first one
()),1)-..."IF" statement in a pivot table.
I need help in writing a "IF" statement in a pivot table. My data consists
of sale orders numbers that may have several line items - I am trying to do a
count on the sale orders and Excel count each item as a separate sales order.
Is it possible to write a "IF" statement in a pivot table? Does anyone have
any suggestions as to how I should approach this?
If you have an order # them leave out the items and then simply set the
order # to 'count'. You will not be able to count the unique orders in the
table with the items in (AFAIK), as Excel will ...table relationship in query
Should it be table relationship in query the same as the relationship of
table when we first designed it?
I asked this because I have a problem in membership table I have pathid, so
this could be many, while in the Imagetable I will have also many member
number, So is it many to many. I am confused on this
Thanks for any idea provided
H. Frank Situmorang
"Frank Situmorang" <firstname.lastname@example.org> wrote in message
> Should it be table relationship in query the same as the relations...Updating a table with a field extracted from a join
Okay, here's a fun SQL question that's got me stumped, but it takes a bit to
explain. I want to update a table with a value extracted from a join of two
others. The three tables are Music (a list of sheet music), Concerts (a list
of concerts) and SongPerformances (a list of the individual songs performed
at each concert). I want to update Music.LastPerformedSeason across the
board with the season of the most recent concert at which that piece was
performed, as found in Concerts.ConcertSeason. The problem is that because
each concert has more than one piece, the MusicI...When message changes from text to HTML format, font is not the default
My outlook 2003 default format is HTML. The Default fond for new/reply
messages is Arial.
I get a message in text format. When I manually change the format of
this message to HTML, the font of the message is Times Roman.
How can I make outlook automatically use the default font (Arial) as
the font for messages changed from text to HTML ?
...Can not get Excel macros to format/save charts--help??? :(((((
Help??:((( I've spent the last 5 days searching on this forum for problems
similar to what I have but no luck! I am trying to use Excel macro to create
a simple bar chart and to format the chart type/etc...but the macro keeps
erroring when I try to run it.
The debug points to "
Set ActiveChart = ActiveSheet.ChartObjects(Chart1)" run time error 1004.
No matter what I name the chart, it errors.
I'm advanced at Excel but not editing macros with VB.
I'm at my wits end and hope that someone can help me :((
You do not set the Activechart ob...How to not have formula change after inserting column from another sheet
One file - a few sheets. I run a macro weekly to copy column B of my
CURRENT PORTFOLIO sheet and insert that data between Col I and J (Moving
older data to the right - off the screen.) I then populate col B with
this weeks data. That works fine, BUT another sheet of that file (
GRAPH) uses that data to track a few moving averages. To keep the GRAPH
sheet accurate, after the macro I then have to modify the contents for
the SOURCE field of the graph because NOW $I$1 becomes $J$1 and $I$28
becomes $J$28. I can't use an INDIRECT command - I get an error. Name =
Weekly Moving Average, ...Formatting when combining text & value in a cell
The value of my cell is
="Product Margin is "&Z5
Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I
format the percent when combining text & value? Thank you for your
="Product Margin is " & TEXT(Z5, "0.0%")
In article <email@example.com>,
"John13" <firstname.lastname@example.org> wrote:
> The value of my cell is
> ="Product Margin is "&Z5
> Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I
> format the...Additional Table
Please advise me how can I add table to the Microsoft CRM
and link it to the existing table in the CRM.
The current capability to link a table and reference an
existing base Microsoft CRM table is via the SDK only,
nothing out of the box. The SDK link has some example to
linking with external databases/tables...
Microsoft CRM SDK info:
http://www.workopia.com/Links.htm >> Other MSCRM Online
i would like the word "need" to appear in cells that are blank. i can do
something similar with conditional formating where the blank cells turn red
when empty... but i cant figure out how to have words inserted instead.
You can't. Conditional Formatting can't insert text into a cell.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Daveed" <Daveed@discussions.microsoft.com> wrote in message
>i would like the word "need" to...Conditional Number Formats
I would like to change the number of decimals shown for
each number in a row of 50 columns based upon its value.
For example, if the number is >100 then no decimals; if
between 100 and 10 then 1 decimal place; and if <10 then 2
I thought I could use conditional formatting, but it
appears that technique only allows one to change fonts and
backgrounds, not the formats of the numbers themselves.
Is there any work-around or other tool I can try?
Thanks in advance.
You could try the conditional formatting addin at
http://xldynamic.com/source/xld.CFPlus.Download.h...Pivot Table conundrum
I am logging telephone calls per month and have been playing around with the
pivot table function, I'm having a problem in that I want to specify the
number of rows to the endth row, ie. 65536 to throw up the cost per call in
the table so that in future when I add call data to the master sheet the
pivot table will update autmatically, when I do this the result in the table
records the number of events as opposed to the costs, I should point out
that I am using the layout facility within the wizard correctly as
instructed, it seems to work fine when the range is to the end of the las...Changing Quote status from Active to Draft
After we re did our picklists for reps (were originally not working - not
done right), it erased that data from all our past quotes. i need to run a
work flow rule to chang the Quotes status from Active to Draft, but don't
want to do that if it will affect the orders created. Can someone please
help me with this.
It really didn't "erase" the data. The problem most likely is that you
removed the entries for the previously saved values. You could just update
the numeric value of the underlying records with SQL (not supported, but in
this case safe). Othe...how to turn off "smart" formatting
-Type in some text.
-Format as Bold and Underlined.
In A11 (unformatted), type in a word and hit enter.
On my machine, the formatting is automatically changed to
Bold and Underlined.
Is there a way to turn this "smart" feature off?
Tools / Options / Edit Tab / Uncheck 'Extend List formats and formulas'
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that mak...How do I change chart cell from pixel to inch?
I am trying to modify a chart sent to me. Cell width is in pixels. How can
I change it to inches.
Perhaps this site can help. It gives a pixels to inches conversion.
> I am trying to modify a chart sent to me. Cell width is in pixels. How can
> I change it to inches.
You mean cell width or chart width is in pixels? Where are you reading
this size? It's probably in points, by the way, not pixels. There are 72
points to the inch, and dependin...