putting a set of values into a group of bins
I have a column of numbers and I want to count how many are between 1 and 10, 11
and 20, 21 and 30, etc. I have been unable to develop any expression for the
COUNTIF function or a pivot table that works. Is one of those the way to go, or
is there another alternative.
You may want to read about =frequency() in Excel's help.
It sounds like a nice fit.
Elliott Alterman wrote:
> I have a column of numbers and I want to count how many are between 1 and 10, 11
> and 20, 21 and 30, etc. I have been unable to develop any expression for the
> CO...Put % in ( )
Is it possible to format a cell to stay like it: ( -10% )?
With this format (0%), the excel shows this - (10%)
Thanks a lot!!!
Try this Custom Number Format:
Select the cell(s) to be impacted
From the Excel Main Menu:
Those settings will display:
10% as (10%)
-10% as (-10%)
0% as (0%)
Is that something you can work with?
Microsoft MVP (Excel)
(XL2003, Win XP)
<firstname.lastname@example.org> wrote in message
news:4188b0ad-a272-455...Need a folder that automatically puts a contacts emails in it?
I am looking to create a folder that when one of my contacts emails me, the
email will go directly into that folder. Does anyone know how to do this?
Use rules to move mail received from "People or distribution list" and
specify the person whose mail you want to move.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Brian Dalton asked:
| I am looking to create a folder that when one of my contacts emails
| me, the email...Remove Percent Sign via Formating
I would like to remove the percent sign by formating
processes, such as
50.2% to 50.2
I know we can change 50.2% to general cell format then
multiply 100. But I would like to do this by formating
because I have a huge file with some headings here and
not possible with formating
"Charles Deng" <email@example.com> schrieb im
> I would like to remove the percent sign by formating
> processes, such as
> 50.2%...Rule to Automatically Put Messages in Trash when Deleted
can you write a rule to automatically put mail in trash
when deleted so you don't have to remember to clear out
In Outlook 2002 you can go to TOOLS/OPTIONS/OTHER and the
top area is called GENERAL. You can select a box which
will EMPTY DELETED ITEMS ON EXITING (Outook).
Early versions of Outlook also had that ability, but I'm
not sure exactly how to get to it.
>can you write a rule to automatically put mail in trash
>when deleted so you don't have to remember to clear out
...read only Publisher document
Can a Publisher document be saved as a read only document and emailed as
such? JPG files don't have live links.
If the recipient doesn't have Publisher, it wouldn't matter whether it was
read-only or not. I would suggest using .pdf files.
MVP Microsoft [Publisher]
How to ask a question
"Betty" <Betty@discussions.microsoft.com> wrote in message
> Can a Publisher document be saved as a read only document and emailed as
> such? JPG f...How do I put it back?
In Microsoft money 2003. Used to: When I put on my paycheck I would have a
window pop up with seperate catagories, "taxes", "healthcare", ect. there
were four of them. Now when I put them in I just get one "spit catagories"
window. I don't know how I changed it or how to change it back. I can't
even find any support that can/ will help me. If anyone knows Please let me
know. I will be greatly indeted to you. thank You.
"Derek" <Derek@discussions.microsoft.com> wrote in message
news:D9D38C7E-D837-4376-99D3-79C760EC4F85@mic...Exchange 2003 Message Formatting
Is there a way to default the message type for a single recipient globally in
exchange rather than in individual accounts?
On Fri, 10 Mar 2006 05:25:20 -0800, Geoff
>Is there a way to default the message type for a single recipient globally in
>exchange rather than in individual accounts?
Group policy using the OUtlook adm.
The problem when we communicate to our HQ in Germany who use Lotus Notes and
cannot read the email.It appears as a winfile.dat. We would like the ability
to send messages to HQ sending as a plain text email by ...Mecorma and GP- Date format
We have made all the necessary changes to comply with CPA Standards which
come into effect in September for Canada.
However, we would like to make a change to the Date format. Right now we
have YYYYMMDD but there are no spaces. We would like to put spaces or dashes
between the areas such as YYYY-MM-DD but the drop down menu does not give us
this option only slashes which are not acceptable.
Is there a way to do this within the Mekorma or is it a change within GP
You would ...How do I put spreadsheet on my xp?
I can't get any spreadsheet on my computer. Do I download it from the
internet or do I go and buy soft ware for it?
you have to buy Office/Excel for example or you may try openoffice
"Chere Collier" <Chere Collier@discussions.microsoft.com> schrieb im
> I can't get any spreadsheet on my computer. Do I download it from the
> internet or do I go and buy soft ware for it?
Excel is not included with Windows OS.
It is pa...I want to put in 2-2 in a box in excel but it aoutomatically chan.
Enter it as '2-2 or format the cell as text.
(remove nothere from the email address if mailing direct)
"ME" <ME@discussions.microsoft.com> wrote in message
...CAN I OPEN A PUBLISHER 95 DOCUMENT IN PUBLISHER 98 VERSION
CAN I OPEN A PUBLISHER 95 DOCUMENT IN PUBLISHER 98 VERSION
> CAN I OPEN A PUBLISHER 95 DOCUMENT IN PUBLISHER 98 VERSION
Lose the caps. It's considered yelling, is incredibly rude and makes your
posts very hard to read. If you're having problems, ditch NAV.
In memory of MS MVP Alex Nichol: http://www.dts-l.org/
(1) Lower your caps. It's considered rude, as if you are shouting.
(2) Have you tried?
MVP Microsoft [Publisher]
"SHONA" <SHONA@discussions.microsoft.com> wrote in message
I'm trying to create a letterhead that prints the Advisory Board members on
the left side (1.5" column) and keeps the second column free for text, but
every time I create two columns, it goes into newsletter format and spreads
the names of the Advisory Board over both columns. Is there some way to keep
that text in the first column?
See the "More complex letterhead" example at
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope,...Putting all outbount mail in particular mailbox
We have several users using Outlook 2003, connected to Exchange 2003.
When needed, they use "Send As" (or "From") feature to send outbound
mail as particular user (for example firstname.lastname@example.org). When they send
mail like that, it stays in their Sent Items. Is it possible to put
that outbound mail in email@example.com mailbox Sent items too so that
we can centrally manage all e-mails users sent, not having to inspect
each users Sent items?
What would be the cleanest way to do this?
There's nothing in Exchange that will do that for you, sorry...Two documents on one page
I created a flyer that is half-page size, so it easier to fit onto bulletin
boards. In other words, it is 8 1/2 inches wide by 5 1/2 inches high. I
want to be able to print 2 on one 8 1/2 by 11 page, but for the life of me I
can't figure out how to do it. I've tried various page layout settings. I
saved the document as a tent card layout, to get the size I wanted, but am
unable to save it as a full page document and get 2 of them on there. Please
There could be a setting in your print driver to do that. Or if you convert
it to a .pdf file (with third party softwa...formatting specific cell
I have a large document , large in width, and large in height. All of my
cells are formatted for 'wrapped text', but one particular column, column H
will not format like all of the others.
My question, which is probably silly, is: Is there a limit as to how much
text you can create in just one single cell? Do I have too much text in this
one specific cell that it will not format correctly.
It's odd that ALL of my other cells will format, but this one particular
cell will NOT!!
Look up specifications in help
"KristyLynn30" <Kris...How do I merge excel information with a word document?
I need to create a way to place excel information into word documents that
are already created to. Differant information in differant forms. They are
legal forms and would like to insert the data without manually dong so in the
document. I'm using Word 2003 and Excel 2003. Any help would be great.
I'd use a Mail Merge. See link for more info.
Please come back if you have more questions.
> I need to create a way to place excel information into word documents that
> are a...Number format #4
How can I keep numbers like "2:3" (no quotes) to stay like that literally,
without being set as hour format or without being divided between them?
Harpsichordist - Music Editor
Preformat cells as text or precede entry with an apostrophe '
> How can I keep numbers like "2:3" (no quotes) to stay like that literally,
> without being set as hour format or without being divided between them?
> Guillermo B...Is there a way to put 2 charts on the same display page?
I use a PIE chart because the numbers in my segments cvary greatly. I would
like to put 2 pie charts side by side on a display page so I may show 2007
and 2008. Can this be done?
Here's some instructions
But when Jon Peltier sees your message, I'm sure he will tell you that
the only thing worse than a Pie chart is two of 'em.
On May 13, 2:54 pm, nedwards <nedwa...@discussions.microsoft.com>
> I use a PIE chart because the numbers in my segments cvary greatly. I would
> like to put 2 pie char...Putting the Quarter on the page
How can I have my worksheet automatically update which Quarter it is?
Quarter",IF(MONTH(A1)<10,"3rd Quarter",IF(MONTH(A1)<13,"4th Quarter",""))))
all on one line, watch out for email wordwrap...........
Vaya con Dios,
> How can I have my worksheet automatically update which Quarter it is?
> Nicki Taylor
If it's only calendar quarters, this is shorter
=INT((MONTH(TODAY())+2)/3)&"th Quarter&...Print Billing Documents
I was trying to 'reprint' all billings in order to post them to our intranet
so that sales people could look them up.
However, when i save the file to html from the "Print Biller Docs" window,
the file doesn't keep the formatting as displayed when i run the print job to
Is there a way to save reprints of billings to a file that maintains the
formatting that was used on the original invoice?
Any alternative approaches implemented?
the only other choices are text and delimited files in the Print Billing
You can also use Adob...Date Format Problem
I am using Windows XP/Office 2003 and have the following problems:
I am making an attendance sheet where in Cell C4 is having value
(01/09/2005) showing Sep-2005 (formatted as mm-yyyy)
>From A5 downwards I wish to have the following
A5 : 9-1 Thursday
A6 : 9-2 Friday
A7 : 9-3 Saturday
I have entered the following formula in A5
=MONTH(C4)&-DAY(C4)&TEXT(C4,"DDDD") which gives me the desired result
My problem is when I drag it down it shows me values which I don't
want...How can I drag and just have Day and the Weekday incremented as
foll...Put Filename Variable in Macro
I have a macro that stores the full path/filename of a file that is needed in
another macro to cell B8 on a sheet named Index. This sets the file location
which can vary by location.
Another macro uses this file to post data to from the current workbook. I'm
having trouble getting the macro to use the filename variable stored in cell
Can you help? Here is the code that's in question:
Dim wbSum As Workbook, wbData As Workbook
Dim FName As Variant
FName = Worksheets("Index").Range("B8")
Set wbSum = FName <==Here's the problem line!
Set wbData ...Where do I put my schema?
I'm developing a internet site for a customer. The customer is supposed to
upload XML documents to the site and the documents shall be validated
against a xsd schema.
How do I publish the schema so that my customer may use it for namespace
validation on their side? The site is an aspx site that has forms
authentication. We do not want to put the schema on the site without any
It can go anywhere your client has the ability to find it. If you want them
to authenticate, then put it behind that authentication. It's just a file,
like an image ...In excel how do i put zero as the first Number in a cell
how could i add zeros as the first number in a cell without a decimal
Start your entry with an ', to read '083, or
Format the cells where you want to insert this as text, and then enter the
> how could i add zeros as the first number in a cell without a decimal
Either format the cell for TEXT (Right-click > FormatCells > NumberTab >
Text > ok), or if you only have a few, just type a leading apostrophe before
the leading zero.........it won't show up and will change that cell to TEXT
Vaya con ...