My query gets date from several tables: Tpurchase, TProducts, TContract,
After ordering the query data by Contract ID (many contracts to one dealer)
and by purchase date (many purchases to one contract), I would like to add
another field as raw number.
This is so i could later create a running sum for the purchase amount by
purchase date rather then by purcahse ID. The problem is that purchases from
earlier dates may have higher ID since they are entered in delay.
So... How do I created numbering for the orders?
On Thu, 20 Dec 2007 09:11:04 -0800, doughnut
<doughnut@d...Built-in Number Format "#,##0_);(#,##0)"
I want to display my negative numbers in parentheses and should be able to
use one of the built-in number formats.
I select (Format > Cells)(Number tab) and in the category listbox, select
The last two items in the Negative numbers listbox do not have parentheses.
The built-in number format that should contain parentheses,
"#,##0_);(#,##0)" has actually changed to "#,##0_);(#,##0)"
Has anyone seen this before ?
I could create a custom number format but this should be built-in.
You'll get the last two number options to include ()...Number of categories
I need to make a macro to change the between tick-mark labels with a value
depending of the total numbers of rows, but I do not now the VB code to put
the number of categories in the graph.
I'm not a expert in VB coding, any help is appreciated,
> I need to make a macro to change the between tick-mark labels with a value
> depending of the total numbers of rows, but I do not now the VB code to put
> the number of categories in the graph.
> I'm not a expert in VB coding, any help is appreciated,
> Thanks, jos
...Printing a merged to file
I have searched for this topic but did not find another similar
I am merging mail addresses to a four up postcard form. If I merge to a
document and try to print it, I either get four copies of the same
address on each sheet or one copy in the middle of the four up form. If
I merge to the printer, I get four addresses per sheet in the right
place. That would be fine, but some of the addresses are long enough
that they wrap and they wrap in a place where the program decides. Foe
example: Johnathan Quixley & Jane Elizabeth Doe may wrap to be
"Johnathan Quixley & J...Revision conversion to a number suggestions ?
I have a problem with Revisioning conversions. I wonder if any one has any
ideas on how to do this better. One of the elements in my database is
drawing numbers and their Revision letter. ie drawing GA123 Revision A . the
next drawing would be GA123 B and so on. My problem is when the drawing
rolls all the way to GA123 AA or Even 3 Letters in the revision ie Rev ABZ.
Currently i take the asc value of each letter and add them togeter to get a
number representing the revision. example Rev AB would be 65+66 = 131 so
when i compair drawings to see if a new one exists i can just...Number Format #10
I've got a large spreadsheet which was imported. Apart from the first 2
columns, the rows consist of number which I need to filter, but this isn't
working. Then I noticed an apostrophe before each number in every cell,
which doesn't show in the cell but up in the formula/text bar.
I've set all the columns to numbers but the apostrophe won't go away.
Please can someone tell me how I can without having to go into each cell as
there are hundreds.
Select all the columns with these "numbers" in them, then right click the
tab at the bottom of t...Add a set number to a random entered number
I have to start a vehicle service record and am trying to add the 6000 mile
service interval to the mileage at service number.
A B C D
1 6000 12000
2 12125 18125
3 18200 24200 etc
A is the mileage at service and C is the next service due.I am trying to do
this without having a cell with a line of 6000 in it and the formula eg
=SUM(A1:B1) in the C cell.Is this possable?Hope some one can help.
HTH. Best wishes Harald
"Cyclops" <Cyclops@discussions.microsoft.com> skre...Print a screen shot in Excel? #2
Can I print a screen shot in Excel
If just a range of cells, select the range and SHIFT + Edit>Copy Picture.
Can be pasted just about anywhere.
If want the whole window, PrintScreen and paste to a graphics program like
Gord Dibben Excel MVP
On Thu, 13 Jan 2005 09:05:04 -0800, "Teacher1"
>Can I print a screen shot in Excel
Hi This is my first post.
please could anyone tell me how:)
if i have for instance 7 cells with different numbers in each cell' ie
21' 56' 87' 99' 21' 33' 15' how can i make another cell automaticall
show the highest number from the other cells (in this case the cel
would show number 99.
Message posted from http://www.ExcelForum.com
If they're really numbers (not text), then
and there's an =min() function, too.
And a couple of siblings you may want to read about in excel's help:
"jim w <...possible to enumerate page numbers?
If any CRM object has big data(let's suppose that Opportunity has 50000
in the View, you can see those data by page number.....
However, by default, it only navigates by one page...In other words, if I
want to see 15 page, I should click 15 times to look at the page...
Any way page number can be customized via CRM system customization?...
I couldn't find it...
For example, if I want to have viw something like this...
1 2 3 4 5 6 7 ..........(Would be last number of page number)
In this way, if I want to look at the 15 page, I only need to click 15
Thanks....The Drawing Contest
Create an original drawing that will encourage you to think how you
can help your community.
...1099 payee account number
I am having quite a bit of trouble with my 1099 processing. It has created a
lot of manual work. Three questions??
1. Is there anyway that you can add the paid amount of two vendors with the
same FTIN together before processing?
2. Is there anyway to get the payee's account number to print on the 1099?
Next year I believe this will be a mandatory thing.
3. Is there anyway that you can get the system to print the "X" in the box
of over $5000 direct sales?
Thanks for any help any of you can be!!! I did it manually last year, but
don't really feel like doing it manually...Formula for numbers=color
I am trying to make a cell or the numbers in a cell turn red when they
are certain numbers, like 20 for example. If I enter 20 in the cell
it turns red. Trying to make a lotto sheet so I can easily find my
On 20 Sep 2004 16:32:22 -0700, firstname.lastname@example.org (Vile) wrote:
>I am trying to make a cell or the numbers in a cell turn red when they
>are certain numbers, like 20 for example. If I enter 20 in the cell
>it turns red. Trying to make a lotto sheet so I can easily find my
Look at Conditional Formatting (under the Format...Numbered headings, TOC, page-numbering, template
I am working on a manual that has chapters and appendixes. I am also trying
to create a template such that later writers can use the template and simply
select the appropriate styles for each heading.
I want to have numbered headings such that I can specify page numbering 1-1,
1-2, ...2-1,2-2, ...A-1, A-2, A-3 etc.
I created my own styles based on Normal, Heading 1, Heading 2, Heading 3 but
with different names and with numbering specified. When I use one of my
personal headings, they act ok in the text, but when I try to specify the 1-1
style of page numbering in ...Card Contest
I'm going to make a guess.................Mary, are you responsible for the
sample card on the Publishermvps.com site?
MVP Microsoft [Publisher]
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.774 / Virus Database: 521 - Release Date: 10/7/2004
If it is the "feeling well", yes. Since I can't win I decided not to get too
Mary Sauer MS MVP
"JoAnn Paules" <jl_amerson@hotm...BCC to print
I want the BCC addresses to print when I print a copy of
the email I sent.
How do I do this?
...printing page numbers
How do you get the page numbers to print on the pages. I can see them in the
program, but not on preview or when I print a page
> How do you get the page numbers to print on the pages. I can see
> them in the program, but not on preview or when I print a page
Adjust your printer margins. The page numbers are falling in your printer's
In memory of MS MVP Alex Nichol: http://www.dts-l.org/
My first thought was that *maybe* they aren't in the document.
MVP Microsoft [Publisher]
"Miss Perspicacia Tick" &...Printing E-Mails with Attachments
when printing an e-mail how do you print the e-mail showing the attachments
in the header?
Colin T <ColinT@discussions.microsoft.com> wrote:
> when printing an e-mail how do you print the e-mail showing the
> attachments in the header?
Try this: Open the message, click Edit>Edit Message, and convert it to
Plain Text. Then try to print it.
...convert number to a set multiple of that number
Is there any way that I can type in a number into a cell and have a formula multiply that number by .397 and have the result show up in the same cell?
Any help will be greatly appreciated.
Only by using VBA, you could get the same effect by putting
0.397 in a cell, copy it, select the cell with the number
and do edit>paste special and select multiply
"CB" <email@example.com> wrote in message
> Is there any way that I can type in a number into a cell and have a
formu...number formats and masks
Hi - I have a list of numbers whose formats i need to
change. For example, the number 79.26 shows up in my
formula bar as 79.25999999. How do I make all those 9's
Format as a number to 2 dec places, menu Format>Cells and so on.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"mike" <firstname.lastname@example.org> wrote in message
> Hi - I have a list of numbers whose formats i need to
> change. For e...Hey Brian, the card contest?
Maybe this year? Doesn't have to be a holiday card, any occasion will do.
Mary Sauer MS MVP
Mary Sauer wrote:
> Maybe this year? Doesn't have to be a holiday card, any occasion will do.
I like the idea of course. And agreed, it doesn't have to be holiday,
but it would be good to run the contest through the holidays and finish
up and pick the winner near Christmas. What do you think?
Microsoft Publisher MVP
~pay it forward~
This p...Tag do not print or forward
In Outlook 2000, how can I tag an email message so that it
can not be printed or forwarded on?
> In Outlook 2000, how can I tag an email message so that it
> can not be printed or forwarded on?
...formula to add number comined with text
i am currently using a basic weekly diary in excel and need a formula that
will count cells which contain numbers along with text
Row 1 -> w/c 12/7/09 12/14/09 12/21/09 12/28/09 Total
> Col A
days 3mtw 5 1w 4mtwt
I need formula that will give total of days across each month as above not
sure if countif formula will work for this or not
each cell will have the number of days used in that week followed by initial
of the day I need the formula to count the number that is at the ...Announcement Coming: Holiday Card Contest 2003
Keep your eyes peeled for the upcoming details and full
announcement for the 2nd Annual Microsoft Publisher
Holiday Greeting Card contest!
Microsoft Publisher MVP
...formating numbers #3
In my columns when I type a number like 6.00, it would be automatically
formated as 6 by Excel. How can I force it to be 6.00 ?
Thank you guys :)