Outlook XP / html format problem
Have a user with a wierd email problem in Outlook XP/2002
(exchange server). When sending an email, it seems that
only the subject is sent, and the whole message body is
blank. I've narrowed it down to sending email in HTML
format. He can read any email in HTML format but when he
replies or forwards, there is nothing in the message, just
a subject. If I set to Rich-text or Plain text and send
new message, it is fine. If I get an incoming HTML
message, and forward as a Richtext ot plain text, it is
I've created another email profile, with no luck. I've
r...Excel amount field formatting error
Excel 2000 version 9.0.6926 sp-3. My amount is 18.00. I select
format-number-currency and my amount becomes $1800.00. Always adding 2
zeroes! It formats correctly if I enter just 18. If my amount is 18.25 it
formats it as $1825.00. I've tried several different formats with no
success. My computer is an hp pavilion xt926. Can someone please help me?!?!
Thank you. Lynn
Hi, Lynn. Thanks for providing all the info---most people don't. Go to
Tools-->Options, and click the Edit tab. Untick "Fixed Decimal" thingee. :)
&q...basic format question...I think !!
I have multiple pages on one sheet running left to right. Is there a way to
adjust the height of one row on one page with out effecting the row across
the whole sheets on either side of it. I know I can merge or insert rows but
I would like to just click and drag the selected cells until I get the
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
The entire row must have the same height. Avoid merging cells -- it cause...Conditional Formating (If statements)
In the conditional formatting box how would I make B4 turn yellow if F12 is
between 10 and 15?
Right-click Sheet, click 'View Code', and paste this into the window that
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rnArea As Range
Dim rnCell As Range
If Range("F12").Value >= 10 And Range("F12").Value <= 15 Then
Range("B4").Interior.ColorIndex = 6
Else: Range("B4").Interior.ColorIndex = 0
If this in...2003 Form fields losing formatting in 2007
I have some forms, created in Word 2003, which when opened as a .docx, all
form fields revert to Times New Roman font but if they are opened as a .doc,
they are in the correct font of Arial.
Anyone got any ideas why and how I can fix this?
Thanks very much.
This doesn't make any sense. Documents always open in the format in which
they are saved. What *exactly* are you doing?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Is it possible to put more than 3 conditional formats?
I want to put around 8... If 0-5 blue, If 6-10 red, If
11 - 15 brown etc....
No, I believe 3 is the maximum.
>Is it possible to put more than 3 conditional formats?
>I want to put around 8... If 0-5 blue, If 6-10 red, If
>11 - 15 brown etc....
You'll find that you can't add more than 3 conditions. i.e. the answer to the OP's question is
No. You would have to use an event macro (maybe On_Calculate) to scan the cells and set the
colors if ...Icon sets - conditional formatting
How do I get Excel 2003 to do this?
I want to be able to add increase and decrease arrow icons to a column of
Upgrade to Excel 2007 or see these products;
"Lou" <Lou@discussions.microsoft.com> wrote in message
> How do I get Excel 2003 to do this?
> I want to be able to add increase and decrease arrow icons to a colum...Adding sums in rows and columns and colouring cells with conditions
I have a long table where i need to add and colour individual cells
based on 'days home' and 'days away'.
The table is uploaded here
In order to automate some of this i'd like to automate some, but
preferably all aspects of this, such as:
1. automatically colour the cell orange for "home" and yellow for
2. add separately in the home and away columns the number of days for
3. add the rows for the alternate lines (ie days only, rates only)
I want to do this without yet another...Opening Page format
Using MS Publisher 2002, I want the opening page to show only a blank
page, not a graphic showing - in a third of the screen - a selection
of "scheme - options - designs"
Help/advice will be appreciated.
If it takes up a third of the page you must be using 640 x 480 -
Go to menu Tools > Options tab General second item down - DE-select
On Wed, 10 Sep 2003 17:44:07 +1000, "���MS�Publisher���"
>If it takes up a third of the page you must be using 640 x 480 -
>Go to me...Wait Activity Condition
We have an activity that is added to the lead record automatically at the
time the lead is created. It is a phone call activity for our reps to
followup with the lead.
We also have a sales process (workflow) set up for once the lead is
converted to an opportunity. My question is:
How can I keep the lead from being converted to an opportunity until the
phone call activity on the lead is completed? I have looked at the Wait
Activity Condition but can't seem to get anything to work.
Any suggestions appreciated.
...Text emails do not format
All of my incoming emails in Outlook 2003 are coming in as
one long line of text. I've gone into my email options
and turned off "Remove extra line breaks from text emails"
but the problem still occurs.
Does anyone know how to prevent my incoming text emails
from turning the entire message into one long paragraph?
Maybe the issue is with the person (or people) sending it.
As a test, log into your webmail account, send yourself
and email and then go into Outlook 2003 and see what it
>All of my incoming emails in ...Work around Conditional Formatting
There are 2 worksheets (Sheet1, Sheet2) containing similar data in my
workbook. I want to underline the text in a cell in Sheet2 if the text in
that cell is the same as the cell in the same place in Sheet1. (For example,
if Sheet1!A1 = Sheet2!A1, then Sheet2!A1 is underlined.) Can I write a
user-defined function to check whether the contents in two cells are equal?
Thanks in advance.
Chips has lots of stuff on duplicates, see www.cpearson.com
Bernard V Liengme
remove caps from email
"Andy Chan" <chankhan...second() format
Is there a way to enter 3.5 seconds and display decmial
point in the second field?
Use a custom format like:
> Is there a way to enter 3.5 seconds and display decmial
> point in the second field?
...Simple Format for Customer Statement
Is there available another format for printing customer statements?
I'm mostly interested in a format that shows charges and payments without
all the details and allocation to invoices.
In other words I need a statement is the old fashion simple (Debit, Credit,
Thanks Morris, I'll try it out.
"Morris Paint" wrote:
> This is our current statement. We are having another one written that shows
> current period transactions in one area and all open invoices in another.
> "Mario" <Mario@discussions.microsoft...MS Word Formatting
When I start a document and use font size 36 on the first
page and go to the second page and change the font it
changes it on the first page.
Also when I highlight a few words to bold or underline it
bold or underlines everything in the whole document.
Does anyone know where I change this setting?? HELP
For Word you need to go to the Word Newsgroup.
If this is an issue in Publisher with an imported Word document, you need to
give substantially more information.
What is the version of Windows, Publisher and Word involved.
Is this a Template you are using, and what type of document...Conditional Max value
i have 2 columns and i'm trying to calculate the conditonal maximum from
These are the columns :
and i try to find a formula that gives the maximum in column one, where
column 2 has value 7
in this case this would be 58
Use the following array formula:
Change the range references to match your data.
This is an array formula, so you must press CTRL+SHIFT+ENTER rather than
just ENTER when you first enter the for...In Excell-2000 where do I set format for date?
In Excell-2000 where do I set format for date?
In some tables I have it in dd/mm/yy, but in the others mm/dd/yy
How do I change mm/dd/yy to dd/mm/yy?
On my w2k Pro, Control Paned date format is set to dd/mm/yy yout it does not
seem to affect Excel
If you select the cells with the dates in mm/dd/yy and go Format>Cells
and in the dialog that opens, go for the Number tab, you can select
the Date formats and choose whichever one suits or select Custom and
type dd/mm/yy into the Type box. This will change the formatting of
Hope this helps!
On 28 Jan, 16:34, &q...Formatting cells for big numbers and formulas ...without the formu
I am stuck with this: If I want cells to display like 20-digit numbers in
numerical form (that is, not the xxx+EXX way), formatting them as a text is
okay. But then I need to add formulas and want the results to be displayed.
But as the cells are text formatted, the result in the cell is of course the
text of the formula plus the number. So my question is - in a cell I want
e.g. "12345678901234567890-sum(A1,B1)" and I want the cell to display the
resulting number, not the formula itself. How do I achieve this?
The maximum precision for a number is 15 digits according to...Newbie Help for Custom Number Formats
I am working on a spreadsheet that I would like to have it append the
inch symbol as part of the number format ("). I figured out that I can
add custom suffixes with the use of the quotation marks, but I can't
place a quotation mark inside of quotes and get what I need. Is there
any way to have Excel do this for me?
I know it seems like a small thing to do, but having Excel add this for
me would save me a lot of time with formulas and all.
Thanks in advance.
j...Vlookups and formats
I am using the following formula to pull in the worksheet name into cell B5
The worksheet name is an account number.
I then use vlookups to look at B5 as the lookup value to retreive various
points of data linked to that specific account number.
The problem I have is the formula shown adove brings the sheet name in as
text and the vlookup sees it as text. I know this because when I edit the
function the returned value for the lookup value is in quotes "1234". If I
type i...Are there any significant differences in Excel 2003 from Excel 20.
I have some reference material for Excel 2002 and just wondering if it will
be suitable for Excel 2003. Has anyone seen any significant differnces?
Not really. You can read a review by MVP John Walkenbach
on his website:
>I have some reference material for Excel 2002 and just
wondering if it will
>be suitable for Excel 2003. Has anyone seen any
...Conditional Formatting in VBA in 2007
I have a series of non-contiguous rows that I want to apply
conditional formatting to. Right now, my code snip looks like this:
With Range(sBegRange, sEndRange)
.FormatConditions.Add Type:=xlExpression, _
Formula1:="=" & sCFCell & ">40"
.FormatConditions(i).Font.Color = 3
.FormatConditions(i).StopIfTrue = False
Where sCFCell is a string value for the cell I want evaluated for the
formula, and i is an integer that increments for each time I create a
new rule (which I'm doing for each row I format).
It...Conditional formatting #87
Can I do a conditional formatting on a range if the value
in one cell in the range = X
in other words can I format the back ground for line 5 if
C5 = X
Use conditional formating.
Select the whole row
Set the condition Formula Is =$C$5="X"
Choose the Format you want for the cells in that row.
"ESREI" <firstname.lastname@example.org> wrote in message
> Can I do a conditional formatting on a range if the value
> in one cell in the range = X
> in other words can I format the b...Access 2003 file format advange?
We're upgrading our system from Access 2000 to Access 2003. I'm aware
that version 2000 databases can be opened in Access 2003 without conversion,
and it did, in fact open, but are there any benefits to converting the
database to version 2003? Or, are there reasons why our 2000 database
should NOT be converted to 2003? It's hard to beleive that it wouldn't
matter one way or the other, and think there must be some advantage to
converting to a file format of "2003" if we're using Access 2003.
Many thanks in advance.
On Tue, 17 Feb 2004 12:31:13 -0500, Si...Pasting Excel chart into Word loses formatting
How can I paste an .xls chart into Word and retain the formatting? I tried
copying and pasting (with Paste Special and regular Paste) and I am losing
the line spacing when the chart displays in Word.
Is there any way to gain control over this?
What do you mean by line spacing? what version of Excel are you using?
One why is to insert as Excel Chart or Worksheet Object.
Another general rule is to create a default size chart in Excel, don't
resize it. Then copy and paste it.
If this helps, please click the Yes button.