There is no change to Print (from web format) in my file menu.
I am attempting to change a file from web format to print document format.
Your help response is to click on "change to print" in the file menu. This
option is not in my file menu. Can you help?
...format cell to show zero if not a positive number
How can I format a column of figures to show that if the result is
zero or negative amount it will just show a zero or be left blank.
I am attempting to show the difference between figures that have been
invoiced to figures that have been added and thus need to be invoiced.
Use a custom format like
MS Excel MVP
"TechnoGram" <firstname.lastname@example.org> wrote in message
> How can I format a column of figures to show that if the result i...change a word file back to a pdf file
i changed a pdf file in to a word file how can i change it back to a pdf file
in microsoft outlook.
Also i could not read the file in word
You post Word, PDF question in Outlook group?
"Ann" <Ann@discussions.microsoft.com> wrote in message
>i changed a pdf file in to a word file how can i change it back to a pdf
> in microsoft outlook.
> Also i could not read the file in word
> Please Help
Did you change it by simply renaming the file extension?
Kathleen Orland - MVP...OL 2002 SP3: Documentation bug about client-only rules
There is incomplete information under the "My rule name contains Client
Only" section of "Troubleshooting Outlook Rules" page (located at
It fails to mention that adding a rule to look for specific words in
recipient's address also will also cause the rule to become client only.
I am trying to evaluate publisher to see what limitations there are for
printing a smal booklet?
How can I turn images on and off or assign an image depending on a data
field on a merge without coding VB? Is it possible or do I have resort to
I would like to dynamically change images on a template and also turn on and
off. What is the best way possible to do this?
AL_LONGO <ALLONGO@discussions.microsoft.com> was very recently heard to
> How can I turn images on and off or assign an image depending on a
> data field on a merge without coding...Translate any english number into English word
I am a beginner. it may be a silly question.
In excel, suppose in one cell a number is appearing as 9. I want to write in
another cell as "Nine".
How it will be possible?
'How to convert a numeric value into English words in Excel'
> I am a beginner. it may be a silly question.
> In excel, suppose in one cell a number is appearing as 9. I want to write in
> another cell as "Nine".
> How i...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Numerical Formatting in a Report
I am trying to whittle down some duplicate files on our server. One of the
lines in the report provides a summary of a particular duplicated file. In
the text box control, I have the following:
="There are " & [subCounter] & " additional copies of '" & [File_Name] & "'
potentially using up to " & [footsum] & " MB of space."
which works, but is ugly. The [footsum] entity is calculated by dividing the
file size in bytes by 1024 and again by 1024 to yield MB. Is there a way to
round the [footsum] calculation to ...How do I format publication design after page 18?
After I hit page 18 I could no longer format the publication design onto the
page. Thought it might be considered the back cover but I even tried
inserting pages and it still happened. Any suggestions?
What formatting are you using? Text? When you setup your project did you use a
wizard? What version of Publisher are you using? Have you tried, insert page,
duplicate all objects on page XX?
Mary Sauer MSFT MVP
"gw" <firstname.lastname@example.org> wrote in message
How do you export an excel document into word without
changing the way it was setup?
Go into word and open up your excel document from word.
If you don't have the converter installed you may have to
install it. Try opening the excel workbook first, if you
don't have the converter installed it will tell you.
Hope this helps.
>How do you export an excel document into word without
>changing the way it was setup?
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...Auto correct text changes
I am editing a document in word 2007 that has been saved in compatible mode.
Whe I try to turn one heading into italics or bold it changes all the
headings in the document to the same formatiing.
Can any one help me to stop this happening. If I then press undo all the
other changes revert back and not the one I have just made. I can't keep
pressing undo everytime I make a change. I just want it to change the words
I am highlighting
Microsoft Word MVP
"David Rudman"...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hemail@example.com> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...colour formatting
Has anyone any idea how to chnge the colour of the text in say a1, a2, a3
simply from the results of what word is placed in cell a4
Use the Format-->Conditional formatting command.
1. Select cells A1:A3
2. Click Format-->Conditional formatting
3. Change the first dropdown (on the left) to "Formula Is"
4. Enter the following formula in the textbox to the right of "Formula Is":
$A$4 = the cell you're testing
"Hello" = the word/phrase that will make the font color change. Make
sure ...Automatic conditional formatting from a list
I need a macro that colours cells if the product name in column A on it's
row matches any in the product list.
There is a list of product names in C17:End(xlUp).Row, that have different
backgrounds applied to each cell in the list.
The macro looks at Column A in the worksheet & compares it to the product
Where it finds a product name match, it goes across to columns I:BJ (on the
matched row) and applies the product name's background colour to any "active
cells" (i.e. value >0).
The following code does this but it's applies...How do i get Harvard style referencing in word 2007?
I am currently writing my Dissertation for my University Degree. I have
found the citation feature extreamly usefull as it automaticaly adds the
referencing to my work.
However, after speaking to my project supervisor, she has informed me that
the citation style will not be acceptable as it is not "Harvard" style.
I was wondering if there is an update that i can download to enable to have
harvard style referencing in my work.
I would apreciate any help that you can give.
I suggest you speak again with your supervisor as there is no such thing as ...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Formatting Text in Network Diagram View
The text in the boxes of my Network Diagram view is cut off. I can't find a
way to make the boxes larger or the font smaller.
Does anybody know how to display a task's full text in a Network Diagram box?
Right Click, select Box Styles
Click More Templates
Use Cell Layout to change cell width and Font to find a smaller one
You cannot select 6 but when you type it it is accepted.
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
...difficulty with conditional formatting
I have a spreadsheet that gets updated monthly and looks like the example below
Jan Feb march April May June
21,000 23,500 22,224 22111 20,111 25,000
I've asked this question before and have gotten great tips but each month
when refesh the pivot table it looses all the conditional formatting and I
start over again. How do I get the pivot table to keep it's formatting when
The conditional formatting needed is if #'s go down for three consecutive
months in a row they are highlighted in red. I need the first...Get/Replace words in HTML control
I have an application that has an HTML control (like the CHtmlEditCtrlBase
in VC7, but in VC6) to compose email messages. I want now to add spell
checking to it. I have the spell checking engine, I have only to provide the
words to it, and I'll get the list with suggestions.
My question is how can I retrieve the text from that control without all the
The second question is, when I have the replacement for a misspelled word,
how can I replace the misspelled word in the HTML control with the correct
I hope somebody has an easy way to do this :)
Mihaly ...how do I format text as strikethrough in Publisher 2003?
I am copying over text from a WordPerfect document into Microsoft Publisher
2003. Text that has been formatted as "Strikethrough" in the WordPerfect
document comes over as plain text with no strikethrough. I have even tried
to just import the document which it looks like it does fairly well at,
except that all text formatted as strikethrough is imported as plain text.
I can possibly believe that Publisher does not have any way to format text
in this way, but I have looked everywhere and cannot figure out how to format
the text in this way. Can anyone help?
You will have to ...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...My Word Document is formated wrong on a PC
Operating System: Mac OS X 10.6 (Snow Leopard)
I went for a job interview the other day and when I looked at the Resume they had printed out the formatting was off. The spacing between the sentences were ok but the type that should of been on the second was half way down the second page. I took my original PC word doc. and opened it up and the Mac and it's the same way only it backwards most the type that should of been on the second page most of it was on the first page. I even made the PC word doc a .rtf file but it's still wrong and I can't se...