Problems with Numbering
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi <br><br>I am having a problem with paragraph numbering. My work insists that documents are presented in a specific format and I have successfully customised an outline number format that is to the exact spec that I need. Generally it works fine and all paragraphs and sub paras number as advertised. <br><br>But, and here's my problem, sometimes a document just won't continue to number in the manner I want. I always write the words of the text first and then do all the form...Why does Money hide my account numbers?
I am trying to review my credit report and there is one item on
there that doesn't look right, and must be at least 6 years old.
My credit reporting agency shows me all but the last 4 digits of
the account. Money, on the other hand, shows me only the last 4
digits. Worthless. I can understand if some people are paranoid
and don't want someone looking over their shoulder at account
numbers, but if that is the case, make everything XXXXX on the
screen because they can see your balances too!
Is anyone really served by this decision the Money team made?
Oh well, back to opening each clos...Can I use named range in data range box when creating pie chart?
I have 75 pie charts to create today. Is there a way to use named ranges in
the data range box to speed this up?
Yes. Just type in the name.
Remove 'Junk' from return address.
"BJackson" <BJackson@discussions.microsoft.com> wrote in message
>I have 75 pie charts to create today. Is there a way to use named ranges
> the data range box to speed this up?
Thank you! I was making it too difficult, thinking I needed to include the
Sheet name along with the name range. ...Tracking Numbers for shipped orders
Is there any way to easily look up the tracking number for a person's order?
We lookup the person's name then 'purchase history' tab...that is the place
I want to see the tracking number so I can track the package.
Is there somewhere else I can see it besides the "journal" which is useless
or the shipping report which is a completely additional step (time waster)
and doesn't allow you to track.
The "track shipping" button in POS screen doesn't show any of our UPS
Besides, that is not where a customer service person would go to look ...Assign Doc # When Creating SOP Returns
It would be nice to assign the document number when creating SOP returns
rather than the system trying to assign the next number.
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/default.msp...Create an identical Chart Worksheet in Excel 2003
I used the F11 key to create a chart, which inserts just a chart as a
new worksheet and gives it a default name, such as chart 2. My
question is, can I create an identical chart as a new worksheet. This
wouldn't be a copy, rather, a duplicate that is pulling information
from the same location in the entire workbook. The reason I want to do
this is because I currently have data for 12 different series, and
each series has 7 values. What I would like to do is keep the same
chart, but reduce the number of values per series from 7 to just 4.
The easiest way seems to me to be to create ...How do I apply a template I created to an existing publication?
I want to change a publication I created to a design that I created and saved
in a publisher format. I do not want to have to recreate the publication in
the new format, just change it! "Publication Options" "Apply Template"
brings up a list of templates that does not include the one I created and
want to use. Help!
Did you save the publication as a template? Save as "Publisher template". What
version Publisher are you using? If you are using 2007 you will have to browse
to the templates.
They are in a folder similar to this (Vista) These folders are hi...Does anyone create sites without using tables for layout?
I know that a trend is to create websites that are pure css, and don't
rely on tables for layout. Are asp.net devs taking that approach also? I
checked a couple of major asp.net websites like newegg.com and they do
seem to use tables for layout.
Any info out there focused on table-less asp.net dev?
Most of us try but I think our dirty little secret is most also cop out and
start using tables here and there when their pages become increasingly
complex. You'll note most of the "pure" CSS sites are often little more than
what we call StackPanels in XAML using CS...Add Page Numbers to PDF
I am looking to progammatically add page numbers to a PDF using VBA. I create
a multi-page PDF using various Excel reports. The PDF then needs to be
numbered sequentially. I have been able to research and find code to add a
watermark to the PDF, but, no luck on page numbering. I am using Excel 2007
and Acrobat 9.
Dim bolResult As Boolean
Dim pdfDoc1 As AcroPDDoc
Dim jsObj As Object
Set pdfDoc1 = CreateObject("AcroExch.PDDoc")
If pdfDoc1.Open("C:\Test\Ranges\Reports\Custom_Merged.pdf") Then
...Auto Numbering for Contacts and Accounts
We need a way to auto number Contacts, Accounts, and Opportunity (similiar to
how quotes, orders, cases, etc..work). Has anyone come across a way to do
this through the use of Jscript or any other means?
You can write a Callout for Autonumbering. Refer to the SDK help for details
There's an auto-numbering sample in the SDK too.
> We need a way to auto number Contacts, Accounts, and Opportunity (similiar to
> how quotes, orders, cases, etc..work). Has anyone come across a way to do
> this through the use of Js..."How does Money Get These Numbers?"
Hi! I know that there's a link to a rather vague answer for the above
question in Microsoft Money, when it comes to how Money calculates
existing data to crunch trended/budgeted items or spread a trended
budget item across the cash forecast graph. The help entry shrugs it
off like "Money uses your existing data." Duh.
Does anyone have ideas of EXACTLY how Money totals and divides your
existing budget items to create a budget entry? Does it add the value
up and total by the number of months you've recorded? (My experiments
don't line up close enough for me to be sure that...SUM of Numbers with colons (:) such as Hours & Minutes
Does anyone know how to get the SUM of a column with numbers formated as
Time (hh:mm) useing the SUM formula to get the total numbers of hours in
that column. For example:
Help is very appreciated.
for your formula use
and format it as a number (format / cells - number)
"CLARKSON PHARMACY" <CLARKSON.PHARMACY@VERIZON.NET> wrote in message
> Does anyone know how to get the SUM of a column with numbers formated as...I need template for a ticket booklet
I am trying to produce a ticket/coupon book about the size of a business card
for my hang gliding business. My thoughts are to use actual business card
stock as the front and back cover and regular bond paper for the serial
numbered tickets. Has anybody tried to do something like this? I am looking
for some assistance as a new publisher user.
I think you've come up with a clever idea if you plan to use the card stock
side margin as the area to staple ten or so cards to make a booklet.
But you want to serial number the cards. Look in help about merging. It'll
probably talk ...How to create an order with products using workflow
It appears that using Workflow we can create a new Order record, but there
does not appear to be any way to add Products to that Order once it has been
Does anyone know how to do this?
This will require custom development.
uMar Khan :: MS CRM MVP
CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.microsoft.com/default.aspx/profile/umar.khan
"Bevan Edwards" wrote:
> It appears that using Workflow we can create a new Order record, but there
> does not appear to be any way to add Prod...Create unique list from duplicates
The solution for this is probably a quite simple array formula wit
COUNTIF, but I cannot seem to get it exactly right. All I want to d
is take a list with many duplicates and list each duplicate once, in
separate list, without modifying the first list.
Thanks in advance,
Message posted from http://www.ExcelForum.com
What you are looking for, I believe, is Data > Filter > Advanced Filter.
Select "Copy to another location" then click the "Unique records only&qu...Counting the total number of cells with specified condition(freque
Can anyone pls tell me how do i count the total number of cells that has
a certain word appear twice or nth times in a column?
The below-mentioned will be the end result. The frequency will be specified
by the user and excel will count the number of cells that has a certain word
appearing twice in a column. Likewise, for Freqeuncy 3, sums the number of
cells with that has a certain word in a string that appears thrice in the
Frequency(input) Number of occurences(output)
...Linking customer number format to a cell
Is it possible to link a custom number format to a cell within a workbook?
Currently I have the number format
#,##0.0"m (forecast)";(#,##0.0)"m (forecast)";-"m (forecast)"
used extensively throughout a workbook
I want to change the text after each number to "m (actual)". I will be
changing the text on a monthly basis. Currently I have to manually change the
format each month.
Not that I know, but if you use styles, as in Word, you could do this in one
step as opposed to changing every single cell.
Juan Pablo Gonz�lez
&quo...how to create a clustered, 100% stacked combination chart
I want to create a chart with 2 100% stacked columns to compare % of 2
Maybe you can use the information here but using 100% stacked columns.
Keri in Vermont wrote:
> I want to create a chart with 2 100% stacked columns to compare % of 2
> different years.
Andy Pope, Microsoft MVP - Excel
...Outlook 2003 (Creating new email)
I have been creating new email for several months now
using Outlook 2003. While I was creating some new rules
for emails, I must have changed a setting.
Now when I attempt to create a new email, it pulls up a
template with wierd fonts, some of my typing doesn't show
up on my screen as I am inputting, my signature I had
created doesn't show up, and it has a different feel than
Any idea what I have done and what I should do to restore
my previous settings?
...Creating custom fields in shema manager
I am pretty new to MS CRM and I am trying to add a field to the
pricelist. I have been looking at the schema manager, but I am unable
to add a field. When I right-click on on the attributes, I choose
'New', but 'Schema field' is greyed-out, so I can't click on that.
Somebody knows what wrong or how I can fix that ? Something I forgot ?
Any help would be appreciated.
...How to I create a tax export that is eariler than last year.
For example itss 2009, when I try to create a tax export report (.txf) I'm
only given options for 2008 or 2009 (partial). How do I create a tax export
In microsoft.public.money, bmwbiker wrote:
>For example itss 2009, when I try to create a tax export report (.txf) I'm
>only given options for 2008 or 2009 (partial). How do I create a tax export
Try closing Money, and setting your computer clock back to a date in
2008. You may have to disconnect from the internet, but probably
not. Start Money again, and generate your .txf file.
I have tried and tried to create a MACRO in Excel that will will delete
a row. I have read several other marcos but have been unable to
translate them to what I want to do. Listed below a sample of the type
data I am talking about. What I want to do is have the macro read the
second number in the colum and everytime it read a 0 it deletes that
whole line of information. This type table will have some blank row
but I do not want to delete. Can anyone help. Thanks in advance. Ron
D60801 0 0 0 0 0
D78555 0 0 0 0 0
E98103 0 0 0 0 0
N04456 0 0 0 0 0
N05482 3 60 0 0 0
N95862 0 0 0 0 0
N96248 3 ...Creating a Distribution List in OUTLOOK 2007
Is there a way to create a DISTRIBUTION LIST in OUTLOOK 2007 that contains
contacts with a specific feature WITHOUT adding members one by one?
E.g., I need a distribution list of all contacts whose e-mail address is in
a particular domain.
The following sequence DOES NOT work:
CONTACTS ---> ACTIONS ---> NEW DISTRIBUTION LIST ---> SELECT MEMBERS ---->
SEARCH (MORE COLUMNS)
When I entered the domain name in the search window, I got no results. Thus,
OUTLOOK did not search the entries of the e-mail addresses.
Thank you for your help.
"...how can I save a publisher created logo in picture format?
I've created a logo in MS Publisher. How can I save the logo in picture
format so that it can be inserted into other programs?
GEL <GEL@discussions.microsoft.com> was very recently heard to utter:
> I've created a logo in MS Publisher. How can I save the logo in
> picture format so that it can be inserted into other programs?
What version of Publisher are you using?
Ed Bennett - MVP Microsoft Publisher
"Ed Bennett" wrote:
> GEL <GEL@discussions.microsoft.com> was very recently heard to utter:
> > I've created a logo in MS Publ...Page Numbers #3
Is there a way to get page numbers in a workbook to run
consecutively from one sheet to the next?
If you select multiple sheets, then print, Excel will
consecutively # the pages.
>Is there a way to get page numbers in a workbook to run
>consecutively from one sheet to the next?
If I understand correctly, you can do this in the
header/footer . You can insert the function and it will
automatically number your pages.
>Is there a way to get page numbers in a workbook to run
>consecutively from one sheet ...