page numbering #19
My page numbers don't show up when article is printed. I like them on the
bottom of the page.
queen of flowers wrote:
> My page numbers don't show up when article is printed. I like them on the
> bottom of the page.
Do other objects in the same vertical position show up? It's conceivable
that you have placed them in your printer's non-printable area.
Ed Bennett - MVP Microsoft Publisher
When creating formula,I use sum to add, product to multiply, what do I use to
If you're adding two cells, you could use:
And for subtracting:
> When creating formula,I use sum to add, product to multiply, what do I use to
...Message colour ?
Someone recently sent me a email that shows up red in my message window ( I
don't use the preview pane ).
I don't have any message rules that would change the colour of that message
or anything like that and the priority of the message is normal.
Anybody have any ideas as to how this is done ? OL 2002.
It's done with the default automatic formatting rules -- View | Current View
| Customize Current View | Automatic Formatting
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
...How do I sort hexidecimal numbers in an excel spreadsheet?
When I attempt to sort hex numbers in a spreadsheet I get incorrect results.
The cells are formatted as text (else the leading 0 would be dropped). I
would like sort results to run from 0000 - ffff. any ideas?
First run a sort. Then create a second sorting column and stick an X where
it is numbers and leave it blank when you have letters. Or vice versa.
I think you have some cells stored as a number. Force them to text. Run a
sort and choose "Sort numbers and numbers stored as text separately".
"Jane Martin" wrote:
> When I attempt to sort hex numbers in a...simple countif formula
Column B in my spreadsheet consists of 10 rows with one letter in each cell.
I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value
in each of those cells is "H". I have tried a simple formula like this
=countif(B1,B3,B5,B7,B9,"H") but it does not work.
Thanks for your help with this formula.
"Brian" <Brian@discussions.microsoft.com> wrote in message
> Column B in ...round up the number
I have a table below:
A B C
1. 123.60 12
2. 178.40 8
How can I set a formular to get the following results:
C1 = 124 * B1 (A1's 123.60 round up to 124)
C2 = 178 * B2 (A2's 178.40 round up to 178)
thanks in advance!
"Lowan Chan" wrote:
> I have a table below:
> A B C
> 1. 123.60 12
> 2. 178.40 8
> How can I set a formular to get the following results:
> C1...formula question #19
Need help on 2 formulas.
here the work sheet
cell A1 will have input either letter DO then a number (i.e. D102) or just
the number (i.e. 134)
cell A2 & A3 will input only numbers. (i.e. 9)
Cells A4 will add A2 + A3 only when cell A1 starts with the letter D (ie
Cell A5 will add cells A2+A3 only when cell A1 does not start with the
letter D. (ie 134)
Can this be done?
you could also use an IF function
-...Colour Rows in Datasheet based on three criteria
I was wondering whether it would be possible to colour rows in a datasheet
(or continuous form) based on 3 criteria. Scenario is I have a series of
jobs that can be either unassigned, assigned and finally "assigned and
I would like all rows that are "unassigned" to be one colour; all assigned
jobs to be another colour and the final section to be a further different
thanking you in anticipation
On Mon, 17 Dec 2007 09:05:01 -0800, PMK <PMK@discussions.microsoft.com> wrote:
>I was wondering whether it would be possible to colour r...help create a formula using the IF command with AND
I need to create a formula for below:
IF A2 is greater than A1 AND A4>A3 then A4 should be multiplied by .04,
if not then A4 should be multiplied by .03. Can someone turn that into
a formula for me?
I'm sorry I should clarify the "if not", if A2 is not greater than A1.
They'll all evaluate the same, so you can use the one that is easiest to
> I need to create a formula for below:
>...Maximum number of recepients for an e-mail message?
What is the maximum number of recepients I can have for an e-mail message
using Outlook 2003?
Depends upon a lot of factors - including what settings your e-mail server
has. There isn't a hard and fast answer.
Ben M. Schorr, MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenote.html
> What is the maximum number of recepients I can have for an e-mail
> message using Outlook 2003?
...Publisher 2003 Page Numbering
Is it possible to number the pages in a Publisher document starting from
a specific page number (eg Page 35).
If it's possible, how do you do it? The help files don't...
> Is it possible to number the pages in a Publisher document starting
> from a specific page number (eg Page 35).
> If it's possible, how do you do it? The help files don't...
Try going to...Insert / Section
**MS Picture It! MVP**
Highlights and FAQs
Greetings from Downunder
One of my colleagues sent me this, something of a puzzle.
She is using XP and Office 2003:-
In My Documents I have a folder of PPTs of hymns and songs that we use in
church. I file any new songs here making sure that they are a golden yellow
text on a very dark blue background. This is the way it has been for about
This morning I went to use some of them in the presentation for this coming
Sunday - and would you believe they are now ALL pale yellow on a black
background. Every last one of them - and each song is is a separate PPT
...can i match a colour to its wavelength in nm
I have no clue what nm means?
Mary Sauer MSFT MVP
"aquakem" <email@example.com> wrote in message
Mary Sauer <firstname.lastname@example.org> was very recently heard to utter:
> I have no clue what nm means?
Won't do it.
http://members.cox.net/astro7/color.html claims to have a FORTRAN program
that will do it....Why is colour printouts not same colour as in word?
When I print my logo from Word the colour is correct. When I copy it to
Publisher and print it from there the colour comes out wrong. What could be
Try importing the image rather than copy/paste.
Mary Sauer MS MVP
"DvdM" <DvdM@discussions.microsoft.com> wrote in message
> When I print my logo from Word the colour is correct. When I copy it to
> Publisher and print it from there the colour comes out wrong. What co...list of sequential numbers
I would like to make a colum of sequential numbers say beginning with 401 and
ending with 499. is there a way to do this without typing in each individual
see the answer under your originial question titled "numbers in columns"
"kellyaek" <email@example.com> wrote in message
>I would like to make a colum of sequential numbers say beginning with 401
> ending with 499. is there a way to do this without typing in each
...Change bkgnd colour for some words in CRichEditCtrl?
I'd like to be able to change the background colour for some of the text
in a CRichEditCtrl. I'm comparing two files side-by-side in these controls
and need to be able to highlight some text to illustrate the results.
I could just change the text colour and make the font bold and/or
larger, but highlighting similar to when text is selected would stand out
better, especially if I could also change the text colour to suit.
Is this possible? (I've seen it in some programs, but don't know if a
CRichEditCtrl was used.)
Any help appreciated,
...Reducing Number Precision
I have a large worksheet made up of numbers of high
precision - about 8 decimal places. Is there a way I can
reduce this in excel to say 2 decimal places as I do not
require a precision higher than that?
If they are formulas you can use
if they are constants you can use a number format with 2 decimals,
then apply temporarily tools>options>calculations and precision as displayed
Note that the latter will round the second digit. Then you can remove it
"lcs34" <firstname.lastname@example.org> wrote in message
hi guys, i may be chasing the impossible here, but here we go anyway. ive got
cells in my spreadsheet formatted so that they change colour depending on
what value is input. basically, i want to know if its possible for excel to
recognise how many cells of a certain colour i have and then display the
results numerically. is this possible?
yet again, your really helping me out and it would be greatly appreciated.
If you're using Format|conditional formatting to color those cells, then I think
it would be easiest to just duplicate those rules in helper cells and then use
those helper cel...Removing Border lines and colour for All sheets
is it possible to write a macro to run every sheet and just remove
border lines and colours for all cells in a sheet for every sheets in
I know macro is like this but can't really think how I can loop this.
Can anyone help?
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borde...Auto numbering now allowing me to restart numbering
I have a document with multiple lists and Word will not allow me to
restart numbering of lists once I get to a certain point in a lengthy
document. When I highlight the items to be renumbered and go to
Format>Bullets and Numbering, the Restart Numbering option is grayed
out. I have a rather convoluted work around that may help with the
diagnosis of the problem. In order to force it to renumber, I add an
extra line to the previous list. So for example if the last item is
10., I hit ENTER and it gives me 11. I can select 11, and it will
allow me to restart numbering on that one...Align Numbers To The Right
I am new to Excel and was practicing with a worksheet. I wanted only to
place a $ sign at the first number in the column. When I go to the next
line without using a $ sign and type only my number the alignment is
slightly off to the right. For example: $ 91, 000
How can I correct this?
Try highlighting the cells, then Rignt-click > formatCells > AlignmentTab >
select Right in the Horizontal: box > OK
Vaya con Dios,
"C J" <email@example.com> wrote in message
news:Feedn...Change color of cell after user has input a number
I have a spreadsheet that populates a number of cells. The user has the
option to change the cell values. Now, ifthe user changes a value, I want the
value to be of a different colour.
Say the code-generated value of cell B1 is 137 (black colour)
if the user changes the value to 200, I want the colour to be red
Is this possible?
Thanks in advance...
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "B1:B10"
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With T...Number Range Format Type
I want to have a format for my cells that basically means "the data in
this cell specifies a range of integers". For example, it might say
1-4, or 2-7, etc. Or it might just say 1 which is the same as 1-1
(low val is 1 and high val is 1). Is there a way I can have a format
code for this and use a custom format? Later on in the worksheet, I
want to be able to extract the min and max values of this range from
the cells. The application of this is that a certain column is going
to be used for holding ranges of numbers. Then at the very bottom I
want to add up the ranges to produce...highlight duplicate numbers
If I enter a number into any cell which has already been entered into another
cell, regardless of row or column, is there any way in which my attention
could be drawn to the fact that this number is already in the worksheet, i.e.
by highlighting or something similar.
Conditional formatting will do it with a formula of say
"css" <firstname.lastname@example.org> wrote in message
> If I enter a number into any cell which has already been entered into
> cell,...How can I begin numbering pages(Pub) on first page after inside
I want to begin automatic page numbering on the actual third page. In other
words, the cover and inside cover as well as the back cover and inside back
cover will not be numbered. Can this be done?
What version Publisher?
Go to page 3, Insert, Section, Check Begin a section with this page. Start at
Insert page numbers, if you are viewing a single page spread you will have to
apply the page numbers on both sides.
Create a new master page. Apply to the last page and cover.