Word 2004 formatting
For some reason Word now opens my documents in a defined space in the
center of my monitor. I can enlarge the image (ie, 150%) but the
defined space doesn't change size so I lose text. Changing from
Normal, to Page Layout, etc doesn't fix the problem. What's wrong and
how do I fix it? Many thanks! Jim
When you hit the green button in the top left, what happens?
When you drag the bottom right corner, what happens?
On 18/2/07 1:28 PM, in article
> For som...Tooltip question...
I need to create a tooltip control and show it explicitly at certain position. A
good example is Windows XP warning tooltip shown on login dialog when Caps Lock
is on. This should be possible on any window(even if the target window belongs
to another process) and even if the main window of my application is hidden(only
tray icon is shown). I managed to get the window handle and position of target
window by using system-wide hooks but had no success with tooltip.
Is it possible at all or do i have to create my own top-level popup dialog that
looks like tooltip?
...Serialized items sales question
Is there any way to prevent the sale of serialized items when a
customer is not associated with the invoice?
...CRM email template question
I need to create a email template in HTML format. I put
the html commands in the email the message shows up with
the html commands in the body. The only editing the
template will let you do is font color and size. Where
are the email templates stored on the CRM server so that I
may edit them there? I need to send out an email with
images and links and stuff like that. Thanks for your
You need to cut and paste the html.
"billy dodson" <email@example.com> wrote in message
> I need to create a email template...Captions and Citations won't format differently on same line.
Here's my issue:
I have several figures in my document, which I have captioned using the
"caption" command. Additionally, I have given the source for the caption as
For instance: "Figure 1: Elm Tree (Jones, 2007)."
I have created a Table of Figures, and the table of figures views the
citation as part of the caption. When I try to select the citation and
change it to normal text style (so the table of figures won't recognize it as
captioned text) it will not let me change it if it is on the same line.
My style book requ...Question for all you clever people....
Let me see if I can explain.....
I have worksheet No 1 (called codes) with a list of numbers 1,2,3 etc though
On worksheet I have a list of part number that is around 10,000 lines long.
Each part number have a price ranging from �0 to �2000.
From worksheet 1 I need a formula in worksheet 2 showing that if a price is
between �0 and �29 I need the code number "1" inserted in column A. If a
part has a price between �30 and �199 I need a code of "2"
inserting..........and so on down the 10,000 line spreadsheet.
Please help ;-)
Hope this is clear.
...Sorting while protected
This is a repost. I got the Subject line wrong. Sorry for any confusion.
We are working in Excel
OS Name Microsoft Windows XP Professional
System Manufacturer Dell Inc.
System Model Precision WorkStation T5400
Microsoft Excel version 11.8320.8221 (Excel 2003 of Office Professional
We are trying to sort and filter protected cells.
In the Protect dialog, we have currently highlighted Select locked cells,
Select unlocked cells, Sort, and Use AutoFilter before protecting the sheet.
Of course, we have tried many things to make it work.
The problem is, Auto...button question: two different commands?
Is it at all possible to use the same button for two different commands. I
want to make a subform visible and invisible with the same button.
Private Sub cmdButton_Click()
frmSubform.Visible = Not frmSubform.Visible
"scubadiver" <firstname.lastname@example.org> wrote in message
> Is it at all possible to use the same button for two different commands. I
> want to make a subform visible and invisible with the same button.
Inserted it where?
"scubadiver" <scu...Can Anyone Help me?
I'm new to Pub 2003. I am creating an advert.
I have used the rectangular 'auto-shape' and filled it with a transparent
fade to black. Ofcourse it is very important that it is transparent, but when
I come to print it, it appears as a solid rectangle.
Does anyone know how to change this and basically print how you see it on
Publisher has always had problems with transparency. Create your auto-shape with
your preferred transparency. Right-click, save as picture. Choose .png.
Re-insert into your publication.
http://msauer.mv...Easy formula question -sum of 1 cell to end
Thanks for looking .
How do you format a formula to display the sum of, let's say A1 to "however
far down the spreadsheet goes" without having to name an ending cell?
This sheet has no end and I need to display the total in a column that keeps
I hope I phrased this correctly.
You could do it this way =SUM(A:A), that will cover the full column.
"Edward" <email@example.com> wrote in message
> Thanks for looking .
> How do you format a formula to display the sum of, let's say ...Better support for dynamic content within headers and footers
One of the major limitations that I find there is with Excel is the ability
to display dynamic content within headers and footers. Specifically, without
adding VBA code, there is no way to place anything in the headers/footers
except for static text, the page number, the number of pages, date (in a
standard format), time (in a standard format), file name, sheet name, and
For starters, I would like to see the following new functionality:
- The ability to specify different ways of formatting dates and times. A
good way to do this would be similar to how different formats are ...leading zeros in text format
I receive bulk orders via an Excel spreadsheet, containing many individual
orders with reference numbers.
The reference numbers may be 7-9 digits long, however the field needs to
have 10 digits. The format is set to customize: 0000000000. In this manner,
we always see the 10 digits regardless of the actual number.
The problem we have is that we bulk-load this spreadsheet through a specific
custome built bulk-loader. This reference number field must have 10 actual
digits, not format digits. Therefore a number such as 00865243 becomes
865243 and then will not run through the bulk loa...SUMIF question #3
I have a workbook with column A formatted as dates, and column B containing
numbers. I would like to know how to get excel to tell me how much the sum
of the numbers would be for a given time frame. So, for instance, if I
wanted to know the sum of the numbers in column B that have year 2006 in
column A, etc. There must be a way to do this, but I'm stumped.
Also, can the criteria in the date be narrowed to give me a sum of just,
say, a given month within a given year?
Thanks in advance,
Dates in A1:A30
Amounts in B1:B30
Here are 2 variations of the same formu...International date formats
When performing an Edit, replace on the cell value
10.09.03 (a system genereated date vale of 10th Sep 03)
replaceing the . with /, Excel (and in VBA when recorded
as a macro) sometimes changes the cell value to 09/10/03
(9th October 03). This is driving me potty and have spent
a vast amount of time on it trying to work out what Excel
My Regional settings are set fro the UK.
Any ideas anyone?
"Mike" <firstname.lastname@example.org> wrote in message
> When performing an Edit, replace on the cell value
> 10.09.0...repeat question....still looking for an answer
how are people handling the situation of no salesperson ID
being transferred over from CRM to Great Plains on the
customer card? Also how are people handling the situation
of no tax schedule ID available in CRM? I'm told that my
customer class ID in GP will have to be set up with a
default tax id - THIS DOESN'T MAKE SENSE. Without a
salesperson ID or a tax schedule ID it creates a lot more
work for my accounting dept. they will have to go into
every card in GP and add in the correct tax id and then
they have to go to crm to find out who owns the account,
go back to GP and ...Newbie question
Is there a data that uniquely identifies a CPU among all
PCs? Can someone please tell me what is it and how to get
it using MFC or Win32 APIs.
A sample code or any other reference will be greatly
"Johnny" <email@example.com> wrote in message
> Is there a data that uniquely identifies a CPU among all
> PCs? Can someone please tell me what is it and how to get
> it using MFC or Win32 APIs.
> A sample code or any other reference will be greatly
I...question driving me nuts
Okay...I never thought I would ever have to use excel again. Lo and behold, I
am now the owner of a business and have forgotten how to do some things. I
know how to create formaulas for adding and stuff. I forgot how to make my
calculatons so that my deposit would be broken down. For example say I have 5
of each dollar denomination (1,2,5,10,20,50,100) and coin (1,5,10,25,50,$1).
My deposit has to be 790 (5 of each denomination-150).
What I want my sheet to do is tell me how much of each denomination I should
pull out in terms of numbers instead of dollar amount. For exaple instead of
...Conditional Formatting #28
I use Excel 2002 sp2
Is there a means to have more than 3 conditions for
confitional formatting ? the dialog box only features 3.
many thanks and best regards
J.E. McGimpsey shows a way to get up to 6 different formats using conditional
formatting and a custom number format.
You can't add more conditions, but you may be able to use a worksheet event that
formats the cell the way you want.
Jean Luc wrote:
> Hi everybody
> I use Excel 2002 sp2
> Is there a means to have more than 3 conditions for
> confitional formatting ? the dialog box ...Cell Formatting to disp. ### numbers
I am trying to format the cells so that it only allows three numbers t
To be more descriptive:
We work with zip codes quite often, but, we only use the first thre
Someone sent us a xls file with 12000 zip codes, in one column, and
need to know how to make the column show only the first three digits o
all the zip codes..
there is another problem, when I convert them to a numeric value, i
removes the zero in front...ex. 08245, becomes 8245, but i need to kee
that zero in front.
Message posted from http://www.ExcelForum.com
Assuming your zip codes a...Reprint AP check format on plain paper
Provide the ability to print a "copy" of a previously printed check w/
stub (with "void" in the signature section)
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 pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/defaul...Pivot Chart Refresh cancels all chart formatting
I am using pivot chart with calculated fields, on which I did some quite
sophisticated formatting (combination chart stacked bar / dot plot with
secondary axis ; bar & plot area & grid colors ; labels ; axis & chart
When I click the "refresh" (!) button to update the data, the chart
formatting is lost and the chart reverts to the default formatting (stacked
bar chart with all series)
Is there any way to "memorize" the chart formatting on a pivot chart ?
Loss of formatting is a known problem with pivot charts. There's
inf...Excel default number format problem
I have a user with an incorrect default cell format in Excel. His
default number of decimal places for a cell with numbers is set to 4
instead of 2. I have no idea how he caused this and I have no idea how
to correct it. In case I'm being ambiguous, here is the procedure:
Open a new Excel workbook, choose any cell and go to Format. In the
Format Cell dialog box go to the Number tab and choose the Number
category. The Decimal Places box will be set to 2 by default but in
this user's Excel it is set to 4. How do I get it back to the default
http://www.imagedump.com/index.cgi?pick...formating multiple worksheet via print preview
I have a multiple worksheet workbook that I need to change
several features about all the worksheets (page
orientation, fit to 1 page, etc.). How can I do this
formating and have it apply to all the worksheets selected
in the group rather than having to do it to each worksheet
separately? Thanks in advance.
Group the worksheets you want to change. Change the relevant settings on one
of them and it will be reflected in the others. Don't forget to ungroup the
"Roger" <firstname.lastname@example.org> wrote in message
I am trying to use sumifs to gather information if one of two tests
are true. I would like to be able to make a purchase apear as
executed if Employee 1 (Column N) or Employee 2 (Column O) has
selected Executed from a multiple option list on a form I am exporting
to Excel. I have tried using the OR function, but it won't sum a
logical function, just give me true or false. I know how to do this
if I create an extra hidden line in the table, but I would prefer to
not have to do that. If I were to ask excel to make this calculation
I would say to it "Add the price/cost of all...Ftp fails inside a Shellexecute command
I use ftp.exe inside a ShellExecute command and it works fine when running
my mfc program in Windows XP. When running in Win 2000 it fails and pops up
a message box named "Ftp Folder Error". Inside the message box it says "An
error occurred reading the contents of the folder..."
Some other facts:
1. If I run the ftp command inside a dos box it always works fine.
2. The ftp command receive parameters from a text file.
3. When the problem occurred I saw that the process of the ftp.exe was
diminished very rapidly.
Can someone advise please?
Thanks in advance