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...Displaying a percentage
Sorry if this appears to be a newbie question, but how do I display
percentage figure of another cell. Example:
A2 17.5% of A1
Timeferret's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1917
View this thread: http://www.excelforum.com/showthread.php?threadid=57146
About percentages in Excel
Niek Otten, July 26 2006
In Excel, percentages are stored as fractions; 15% i...Report that display percentage below certain level
I got a spreadsheet contain inventory number from remote site. I need to run
a report to display when inventory below a certain percentage. I try to use
privot table to display the infomration. But it doesn't display everything
below 40%. Is there anyway you can enter an percentage and display all
remote site that below certain percentage (Eample: like 35%) on a report?
A pivot table groups like items, and makes a calculation on each group --
not what you need. You need a filter (Excel's way of saying "query" in
database parlance). If your table...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...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...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 ...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...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?
...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...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...create a csv file type format for a centrally access address book
We have Outlook 2003 clients on a LAN with a Small Business Server 2003
Standard editon box. We require a single fax document sent to new or
existing clients with using our shared fax service from the SBS. Is there a
way to create a .CSV file type format in Microsoft Excel for our new client
database and import this information into Exchange as a seperate address
book for fax use? Thank you in advance for your assistance.
See my response to your post in the contacts newsgroup.=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart...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...compute a percentage
How do a compute a simple percentage and how do i form a ratio. I am taking a
statistics class and this is the first time I have ever used excel and my
practice assignment says to compute the percentage of women and men enrolled
Then it says form a ration of female to male.
Appreciate any help.
For a single year:
In A1 enter the female enrollment
In B1 enter the male enrollment
In C1 enter:
=A1/C1 and format as percentage for percent female
In D1 enter:
=B1/C1 and format as percentage for percent male
In E1 enter:
=A1/B1 for ratio of females to ma...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...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...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...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...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.