Drawing Page Orientation Doesn't Match Printer Paper Orientation #2
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
The thumbnail preview shows that the drawing page orientation doesn't match the printer paper orientation. I can not get the page orientation to match. When I change it to letter, I can see the document change to landscape. When I change the page orientation to landscape, it changes the document to portrait. The two will not be the same. This is in Word 2008, it also happened in an older version of Word. Help, what do I do?
...How to change the index/indexer server back to its old name??
Our WSS search server (Search Server Express I think) thinks its
server is called X instead of Y.
Any attempt to work with the crawling rules results in an error, it
thinks the search service is offline, though search service really is
Is there any way I can get the search server to know that it should
look for a server called Y instead of X??
First I would add a host file entry or a DNS entry for the old name to get
things back up and working as a temporary measu...Index Match Functions
Has anyone ever combined the Index and Match functions to do lookups?
how do i enter my 401k matching transaction?
<firstname.lastname@example.org> wrote in message
> how do i enter my 401k matching transaction?
> Thanks Dave
...how to match the color of a button with its background?
I have a owner draw push button. I associate it with two bitmaps, one
is down and the other is up. Is there a way to make the bitmaps's
background color match the color of the window where the button is
located. I manually choose the best matched color but still the result
is not good. I can even see a white border line (not drawn by me) when
the button is pushed. Please help. Thanks.
May Young <email@example.com> wrote in message news:<408473...match data to reference then vlookup
I hope that I can explain this..............
I have three seperate spreadsheets each containing data that may match other
data in column1 of one another. I do not have the option of sorting the data
in any of the three spreadsheets. I need the data from Column55 of each of
the spreadsheets wherever the data in column1 is equal or matches.
I need to know what spreadsheet1, spreadsheet2 and spreadsheet3 contain in
Column5 for all matching data in column1. I need the results of this query
to find data into one spreadsheet.
Is there an answer other than database?
...Outlook 2007 Search always returns no matches
Any search I do in Outlook 2007's new search box returns no matches.
I watched the Indexing Status as it progressed, and now it says "Outlook has
finished indexing all of your items"
But, searching on anything, even the word "The" or "a" returns no results.
I'm searching all Outlook items. I'm on an Exchange Server via VPN.
Anyone have any suggestions?
I uninstalled Office and re-installed and the problem went away...
"Tom" <firstname.lastname@example.org> wrote in message
> Any search I do i...Without Matching Query Limit ?
The Without Matching query wizard works fine until you select more than 13
columns to compare. My guess is that the 13 " AND " 's in the SQL left join
statement are the problem.
Unfortunely, my tables have 16 fields to compare.
Any sugestions ?
>The Without Matching query wizard works fine until you select more than 13
>columns to compare. My guess is that the 13 " AND " 's in the SQL left join
>statement are the problem.
>Unfortunely, my tables have 16 fields to compare.
Don't use the wizard ;-)
Seriously, after you d...Matching data in different sheets but slight difference in time va
I have two sheets as follows:
Date / Time / Number Dailled / Duration
22/1/10 10:00 01234123456 00:01:57 0.789
Date / Time / Number Dailled / Duration
22/1/10 10:02 01234123456 00:01:56 1501
I am trying to put the cost of the phone call against the relevant extension
on sheet 2 that has dialled the number dialled. Obviously I can match the
number dialled in both cases, and the...matching numbers with images?
I have thousants of numbers written on column A:A referring to different
objects. All thouse objects have similar filenames with numbers written in
i.e number say 12345 refers to a camera and on the HDD I have the image file
12345.jpg. Is there a macro solution such that when I click on any number in
column A, the image file *.jpg with the same number will automatically
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.720 / Virus Database: 476 - Release Date: 14.07.2004
put the following fo...Match 2 Columns, Return 3rd, Differing Match Types
I have 3 columns of data in my main table. For example:
Blue / 2 / $5
Blue / 4 / $10
Blue / 6 / $15
Green / 3 / $4
Green / 10 / $8
Red / 1 / $1
Red / 4 / $3
What I am looking to do is use some kind if Index/Match function (I
think) to look up the color (column A) and number (column B) and have
the price returned (column C). I have found lots of solutions for
this out there, however the one part I keep getting stuck on is when I
need to look up something like the following...
Blue / 5 = #N/A. I want the answer to be $10 but since the number 5
is not an exact mat...Move to match cells
My spreadsheet looks like this:
A B C
1 000801025-8 009601025-3 2007 000801025-8 2007
2 000801026-9 009601026-4 2004 000801026-9 2004
3 000801028-1 009601028-6 2006 000801028-1 2006
4 000801036-8 009601036-3 2008 000801036-8 2008
5 000801044-5 009601044-0 2007 000801044-5 2007
6 000801044-5 009601055-0 2004 000801055-5 2004
7 000801055-5 009601064-8 2001 000801064-3 2001
8 000801055-5 009601091-2 2006 000801091-7 2006
9 000801064-3 009601095-6 2002 000801095-1 2002
10 000801091-7 009601097-8 1998 0008...Register & Favorites Don't Match
I have Money 2004. My checking account register shows the correct balance.
But in the "Favorites" list on my home page, my checking account balance is
many thousands of dollars lower than the actual balance. How did these get
out of sync? Thanks for any help.
In microsoft.public.money, Larry E. wrote:
>I have Money 2004. My checking account register shows the correct balance.
>But in the "Favorites" list on my home page, my checking account balance is
>many thousands of dollars lower than the actual balance. How did these get
>out of sync? Thanks for ...M2005 newbie Bank Update Accept to match with my pre-entered trans
Brand new user. Used to Quicken. Here's an example of my problem. On 3/10 I
write check number 200 to my church as category Charitable Donation. On
3/17, I update my Banking download and M2005 highlights my transaction with
an exclamation point and compares my transaction with Bank entry. Bank entry
is dated a week after I wrote check, and does not include my church payee
info. If I ACCEPT that the transactions are the same, then I end up with a
3/17 transaction line with no payee, and no category. If I say Do Not Merge,
then I end up with double entries, one complete that I m...Matching the Searched Value to the Adjacent Column
I'm trying to search for the maximum numeric value in one column but I
want the data in the adjacent left column which is a Time variable to
be displayed as the result. How do I achieve this? I can only think of
MATCH, VLOOKUP. The data is quite large.
Thank you very much for your help in advance.
try this idea
Microsoft MVP Excel
<email@example.com> wrote in message
> I'm trying ...90 min -> 1:30
i have a small problem
how can i transvere 90 min into 1:30
Divide 90 by 1440 and format as time.
HTH. Best wishes Harald
Followup to newsgroup only please
"Mario" <firstname.lastname@example.org> skrev i melding
> i have a small problem
> how can i transvere 90 min into 1:30
> tks mario
it workes very well a VERY big THANK YOU
"Harald Staff" <email@example.com> schrieb im Newsbeitrag
My search/indexing started acting up in the last few weeks (constantly
indexing without ever finishing). So I'm trying to rebuild the index. The
index count is sloooooly going down. By my count, I have about 10,000 emails
throughout folders in my in-box, but Outlook seems to find about 25,000
"items" to index. It has been chugging away for about 3 full days, and is
finally down to about 12,000 items. This seems extremely slow to me, does
anyone have a good idea of how long it should take to index this many items?
I've adjusted the power settings to assure ...Indexing Service 02-08-05
I just tried to install CRM sales for outlook on a co-
workers computer and I saw a note that I haven't seen
before when installing it on other computers. It said
that we needed indexing service. What is this, why do we
need it, and how do I get it? Please advise.
Indexing service is stopped by default. Before you'll be able to install the
Sales for Oultook client go into 'Administrative Tools' and then 'Services'
on the computer you're trying to install it on.
Scrole down the list of services until you see 'Indexing'. Double click on
it ...Match Ranges problem ,
Hi all , and a good day
I have 2 ranges , with these values :
(ROW) A B C
1 1 2 4
2 1 3 4
3 1 3 5
(ROW) F G H
1 1 3 4
2 2 3 5
3 1 4 5
I need a macro to compare every cell in myRange2 - first row !! ,
every cell in myRange1 - first row !! , and , if tha value of every
myRange2 is equal with one of the cells of the first row of myRange1 ,
change the value with "QQQ" .
This must to be done in every row . After checking first row of
with first row of myRange1 , to go to next row in myRange2 , and
...My print no longer matches my print preview, help?
I have printed on several occassions without incident, suddenly it is
compressing text to half page. Any ideas?
It is a printer setting. Look for something like *print document on* and a size
box. Some sort of zoom feature.
Mary Sauer MSFT MVP
"Cheryl" <Cheryl@discussions.microsoft.com> wrote in message
>I have printed on several occassions without incident, suddenly it is
> compressing text to half page. Any ideas?
...How do I get rid of 2nd page? It is blank.
I have a resume in Word and it fits on 1 page. I've got this 2nd page that is
totally blank and I don't need it. How do I get rid of it?
This is a multi-part message in MIME format.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"mssunbeam" <mssu...International indexes and stocks
I'm trying to use money2006 to find international indexes end stocks from
I need help
Any particular index/stock you want? Tried using MSN Money to find any?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq/default.aspx for tips and fixes for MS
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx
I do not respond to any unsolicited email regarding Money
"lars" <firstname.lastname@example.org> wrote in message
> I'm trying to use mone...Convert function not working sec to min
I am using the following function and getting the #NAME? error. Can
=convert(F13, "sec", "mn")
F13 currently has the following formula:
which equals 132.67 which represents the number of seconds recorded. I
want to convert that to minutes.
Message posted from http://www.ExcelForum.com/
Works OK for me!
I've replicated your problem statement
=CONVERT(F13, "sec", "mn")
What problem are you getting?
Norman Harker MVP (E...Create an Index for Word Document
Operating System: Mac OS X 10.6 (Snow Leopard)
I have read the help explaination for creating an index, and still cannot figure it out. All I want to have is an index for proper names, last name first, first, and middle. I'm sure it's easy, but I cannot figure it out. Can anyone help? thanks.....
In article <59bb3921.-1@webcrossing.JaKIaxP2ac0>, email@example.com
> Version: 2008
> Operating System: Mac OS X 10.6 (Snow Leopard)
> I have read the help explaination for creating an index, and still cannot
> figure it out....How to share 2nd calendar created in my mailbox?
Don't know if this is possible -
Created a new folder in my mailbox, folder contains calendar iems,
called it xyz
I now have 2 calendars, 1 my default / origional, the 2nd called xyz
If I go to another mailbox, open another users folder, put my username
in, type calendar, it only opens my default calendar. There are no
options to open additional calendar folders of other users.
Is it possible to "share" this 2nd calender simply, or would it have
to be an item in pubic folders.
This is a shot in the dark since I don't have access to an Exchange Server