when I change page size the object does not resize to fit
when I change page size the basic object does not resize to fit .
So I have to drag objects to fit
Microsoft MVP - Publisher
How to ask a question
"basu" <email@example.com> wrote in message
> when I change page size the basic object does not resize to fit .
> So I have to drag objects to fit
This is how it is designed to work. Every program I use works the same way.
> when I change page size t...Public Folder Permissions changed
We have a user who indicated his Public Folder sub-tree had it's default
permissions set to Author. Are there any known issues in regards to a
combination of client software/configurations that would overwrite the
permissions for Defautlt and Anonymous access? Is there any kind of log file
that would tell us when/who changed the permissions?
We are running E2K3 in a 4+1 cluster.
John-O <JohnO@discussions.microsoft.com> wrote:
>We have a user who indicated his Public Folder sub-tree had it's default
>permissions set to Author. Are the...Multiple colors in one stacked bar
I have to create the stacked bar chart based on following data :
Bar# Width Kind
1 50 1
2 70 4
3 30 1
I need three bars, the "kind" column determine the colour of one section in
current bar and the width determine width of this section. How to do it ?
Maybe I have to reformat data ?
Radoslaw Krzyzan , pl.communicat...#Value! errors
I have experienced a problem that I am unable to find a rectification
for. When my staff constantly use the space bar to delete an entered in
error number and leave the cell blank (although there is a space in the
cell) any cell which uses that cell within its formulation shows
#Value! or #####. I am aware that they should not be using the space
bar to delete numbers and the space within the cell is the reason for
the other formulation errors. I guess my question is how do I format
the cell so that only a number and nothing else can be entered?
--------------------------------...Count of values within a cell?
I have a spreadsheet containing a row with data something like:
A | B
1 | 1111
2 | 1112, 1113, 1114
4 | 1115
If I were to do a COUNTA(B:B) I would see a count of 3. What I'd *like*
to find is a way to see a count of all numbers in that row (in this
case, a count of 5).
(replace somewhere in email address with gmail if mailing direct)
<firstname.lastname@example.org> wrote in message
news:1163...INSERTED table no holding exact float value
I have a table A with a float column and a trigger to write to a log on
inserts to table A.
I am using the sql INSERTED table to get the value of the float column,
and insert it into a varchar column in the log (cant be changed, its
generic and used for multiple tables).
I am having a weird issue where the value in the log gets rounded to the
next integer in the audit table, it inserts correctly on Table A though.
Is this a known issue? Is there a workaround? If not, what am i doing
Thanks in advance,
*** Sent via Developersdex http://www.developersdex.co...change default value "save message"
I have a little problem.
When i wanna save a mail message, de default filetype =
I wanna change that to *.msg file.
But i can't get that default!
i have to change it every time manual!
...Showing orders with a certain value of a bit field?
I've included a custom field on the order form. It's a bit field with the
values YES and NO. The default value is NO.
Our employees use this field to tell the system, if an order has been
complete and is ready for invoicing. (We do not want to use the system
possibility of completing an order).
I've made a custom view of orders, where the view criteria is, that the
value of this bit field is NO. And another view where the view criteria is,
that the value is YES.
However, when I select these views, I cannot see any orders.
Could someone please explain, what I'm doing wr...Please Help: compare values in two columns present in seperate tab
How can I compare values in two columns (columns are in different tables) ?
I also want to display the values that dont match in a seperate table.
If values in Column1 from Table1 does not match Values in Column1 from
Table2 then display those values in a seperate table
Is there a way to do this?
THanks in advance
Under query types, there is one for unmatched data and one for matched.
State of Arkansas
> Hi All,
> How can I compare values in two columns (columns are in differe...Money Small Business 2004: Category does not show up in P&L Report
I use Microsoft Money Small Business 2004.
I have created new sub-category Frenchise Tax under Business Taxes with
supplying all requested information. like inclusion in Schedule C ,
type of Expence (Business )
I have assigned this category (Business Taxes : Franchise Tax ) to a
transaction entry in my register.
I run the reports->Business -> Profit and Loss statement, This entry
does not show up in the report. However , when i assign this to other
previously existed category like Federal Taxes , it does show up in
Also, When I look up in category Screen, the trasaction indeed...bulk change of all telephonenumbers
I have all telephonenumbers entered in the format +31555-555555 or
055-5555555 or 0555-555555 (or 06-55555555 for mobile phone). Now I want to
start making phonecalls directly using this field, so I will have to delete
the minus sign in it.
What is an easy way to do that? There are over 500 contacts in the database
each with 1, 2 or 3 phonenumbers. Is there an SQL command for that? Other
I found the answer in the SQL Serbver Management studio Help, Here's the
SET [Telephone2] = '+31' + CONVERT(varch...Business Alerts
Does anyone have a formula that works to alert (in GP 8.0) when
"Pay code information" and/or when "Leave balances" have been changed?
...Deafult Category Reports
How can I change the default category report from the reports view?
You should able go to report manager in CRM, then selected the report -
> Click edit. You can change the report category there.
I don't know if this is what you are looking for. Hope this helps.
Crowe Chizek and Company
On Mar 22, 3:17 am, Magy <M...@discussions.microsoft.com> wrote:
> How can I change the default category report from the reports view?
If you are using crm v3, I don't th...Printing Color-Coded Worksheet in Black & White Mode in Excel 2003
I work with farily complex Excel worksheets which require print outs
as both hard copy and PDF. I normally keep the formatting as they are
and select [Black and White] in [Page Setup] [Sheet], as this
preserves the integrity of the financial model while printing out a
clean copy for the enduser.
However, this function basically converts everyting color-coded to
black & white, including cell shading patterns; I normally accentuate
certain important cells by shading them in black and using a white
font color. While I want the output to be black & white, I do want
to preserve this p...how do i pick up the values ?
This is a multi-part message in MIME format.
I have this XML file, and i am not sure how do i read this xml file and =
read it to an arraylist, for which i use to fire some SQL statements.=20
I want to be able to pick only xml attributes, say, which belong to =
Section=3D"two-4" and put them into an arraylist and similar for the =
rest of the Section attributes.
i had got the code below working, till the time, i had to change the...Restrict Changing Distribution Group Members
Is there any way to restrict which users can change (add/remove) who
appears in a distribution group as members?
It is all user that are able to modify group membership or just a subset
because by default not everyone has this permission, apart from Domain
admin, etc. Are these users with elevated privilidges on your domain?
Take a look in the security tab on afew of your distro groups. Check which
groups or users have read members and write members. You will need to turn
on Advanced Features in ADUC, click the advanced security button in
properties for ...changing servers
I am wanting to purchase publisher for my office. We are preparing to upgrade
to a new server in a few weeks and am worried that I will have to repurchase
publisher when we switch over. Will my publisher program be available post
changeover, or should I wait until after the change to buy the product? I am
sure this isn't a very smart question but nonetheless I would like to know
before I make my purchase.
Im not exactly sure what you are asking, but Publisher is not network
friendly...sure you can install Publisher on your local machine and save
files to the server, but Publisher i...Get values from blank cells
I have some width and height values in several columns with a lot of
blank cells of sheet2. Like this:
A B C
blank blank 2*987
blank blank blank
blank 4*500 blank
5*400 blank blank
How can I get only the cells with values in column A of sheet1:
Can this be done!
Thank you so much
What do you want to do if there are two values in a row? Average them? Add
them? Both of these would work as long as if the values were numbers or
"canvas" <spyele123@gmail...change the format of today(ctrl-;)
when I insert today using shortcut(ctrl-;),
the format is yyyy-mm-dd by default.
I want the format of yyyy.mm.dd.
how can I change that?
I use korean version of excel 2007.
I think that Excel uses the Windows Short date format.
You could try changing that short date format via the control panel.
But remember this setting is used by all of windows.
> when I insert today using shortcut(ctrl-;),
> the format is yyyy-mm-dd by default.
> I want the format of yyyy.mm.dd.
> how can I change that?
> I use korean versi...changing date format not working
After selecting a column and changing format to custom date yyyymmdd. The
changes do not take place. Double Clicking in the individual cells
afterwards bring up the desired results.
Your dates were entered as Text, which isn't subject to Number Formats.
You can coerce them back to XL dates by copying a blank cell, selecting
your dates and choosing Edit/Paste Special, selecting the Values and Add
Change the format to your desired one.
In article <F3750B33-33C2-4C98-8696-E1F81FD2A796@microsoft.com>,
"RickSenn" <RickSenn@discussions.microsoft.com...Save Changes? #2
Sometimes, but not always, Excel asks if I want to save the current file,
even though I've made no changes. Does anyone know why this occurs, and if
there is a setting I can change to avoid the prompt unless actual changes are
There are a number of functions that will update themselves when
the workbook is opened, and this causes Excel to act as though
the workbook has been changed. These functions include NOW() ,
TODAY(), ROW(), etc. See Volatile Functions in help for more
Microsoft MVP - Excel
Pearson Software Consult...change HTML-mails to plain-text
My Problem is with incoming HTML-mails. If you open the
mail and activate in the menue EDIT-edit (bearbeiten) e.g.
Word or Excel will be opened, although in the menue TOOLS-
Options-E-Mail-format Word is NOT activated as an editor.
I want to stop this behaviour, becaus some PCs aren't able
to print those mails or even see the full contents (the
mails end with ">SPAN". Couldn't find another entry
therefor in the www.)
Aren't there any professionals reading this?
silke <email@example.com> wrote:
> My Problem is with incoming HTML-mails. If you open the
&...Hi all need to know how-to make protected areas within a document that won't change no matter what!
Operating System: Mac OS X 10.5 (Leopard)
hi all, i am editing dozens of similar documents each week that all have a template like format but there is nothing to prevent me from messing it up while editing. for example, take this snippet:
<h2>EVOCOTIVE TITLE FOR YOUTUBE MOVIE USE KEY PHRASE ONCE</h2>
<center> <object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/H2MpyODTLnY&hl=en&fs=1 <http://www.youtube.com/v/H2MpyODTLnY&hl=en&fs=1>"><...two colored graph
i regularly create line graphs that include current data and projecte
data. i can change the line colors but i would like to change th
color of the grids so that the projected portion of the graph i
different than the grids for the curent data. using the gradient fil
option is not acceptable. any way???
jfillioe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1623
View this thread: http://www.excelforum.com/showthread.php?threadid=27645
You could construct custom gridli...Extract names from string based on value list
I have a list of productnames and a list of brandnames.
I want to supply the productnames with an attribute "Brand".
I am currently manually filtering the list of productnames based on
"Contains... Brand" and adding the Brand to the product using copy paste,
but this takes me too long and I can only match records one brand at a time.
Can I make Excell search through the list of productnames and whenever it
comes across a brandname within the string of a productname it will add it to
the column next to it?
Assume productnames running in A2 down