Can I stop Publisher capitalising the first word of a line
I want to choose whether the first letter of the first word in a line is
capitalised, it can be done in Word, can it in Publisher
Tools, auto-correct, clear Capitalize the first letter of sentences.
Mary Sauer MSFT MVP
"cliveroberts" <firstname.lastname@example.org> wrote in message
>I want to choose whether the first letter of the first word in a line is
> capitalised, it can be done in Word, can it in Publisher
Do you have a formula or something that I can use in
conditional format to tell if a cell contains a formula.
>Do you have a formula or something that I can use in
>conditional format to tell if a cell contains a formula.
You could use this macro
.ColorIndex = 6
.Pattern = xlSolid
Copy/paste this UDF to a general module in your workbook.
Application.Vol...how do i put formula to find difference between two dates
Re: how do i put formula to find difference between two dates
Put in C1: =B1-A1
A1 contains the start date, say: 01-May-2005
B1contains the end date, say: 10-May-2005
For the sample dates in A1 and B1, C1 will return: 9
Pl post your question within the message area in future.
The "Subject" line is meant only for some key words/descripts, not to house
your *entire* post
GMT+8, 1� 22' N 103� 45' E
"A.D" <A.D@discussions.microsoft.com> wrote in message
news:6A8ACB02-0724-4A0B-BB...where can I find a door hanger flyer template
I am a mortgage broker who wants to market appartment complexes and I
stumbled accross a template a few weeks ago for door hangers and now I can't
find it. Does anyone know where I can get one of these? I appreciate any
HP has several on their site but they are .pdfs. That won't help you unless
you have Acrobat, not just the reader.
MVP Microsoft [Publisher]
"Doug" <Doug@discussions.microsoft.com> wrote in message
>I am a mortgage broker who wants to market appartment co...97: How can I find duplicate entries in a column?
Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Message posted from http://www.ExcelForum.com/
Insert a helper column:
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
http://ww...How to find reports
Hi to all... I'm new to GP as well to business processes. I modified
the report "SOP Blank Invoice Form" and want to know how can I see this
report. I know how to access reports, but don't know under which
"Sales Report" I can see this specific report.
Thanks in advance.
Well, when you print sales invoices, select the Blank Invoice Form.
> Hi to all... I'm new to GP as well to business processes. I modified
> the report "SOP Blank Invoice Form" and want to know how can I see this
> report....Unable to find complete headers in Outlook 2002
I get quite a bit of spam and I want to be able to forward
the spam to their ISP. But I connot find the complete
headers for the message in outlook 2002 Can you please
Either open the message and click View | Options, or right-click the
message in the Inbox and select Options.
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Sandra Gordon" <email@example.com> wrote in message
> I ...automatic replacing of vbe code for multiple workbooks
hi all a got a workbook called.. Replacer, it contains this macro:
On Error Resume Next
Dim Wb As Workbook
For Each Wb In Workbooks
If Left(Wb.Name, 6) = "MI.F@S" Then
Wb.Sheets("sheet1").Range("P2").Value = "-1"
for each workbook in open workbooks whose name begins with "abc", i need to
replace or cancel a line or a piece of vbe ..
maybe this one:
If (Weekday(Now(), vbMonday)) Then
aWS.Range("V104").Value = aWS.Range("V104").Value * 2
can anyb...cannot do a differential backup "can't find store or acc denied"
I am using the same account that i used to install
exchange. I can make a full backup but not a differential.
the user is in
exchange enterprise servers
"james" <firstname.lastname@example.org> wrote:
>I am using the same account that i used to install
>exchange. I can make a full backup but not a differential.
>the user is in
>exchange enterprise servers
What else works? Incremental?
If you're not using NTBACKUP, have you ...Finding linked cells to other workbooks
I have some workbooks that ask me if I wish to update links and I can't
find the links in the workbook. Some of my worksheets I did a copy and
paste special values, but there are a few worksheets that I can't do
this on. I need to be able to find the linked cell and eliminate it so
that the pesky message to update links doesn't appear when the workbook
I'm sure there should be a simple solution to this, I just don't know
what it is?
Thanks for any help.
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/...How do I find a file/spreadsheet that Excel says is Already open but I can't find it?
I was working on a spreadsheet that I use almost daily -- "Account IB".
I inadvertently left clicked my mouse -- was unaware where the cursor
was at the time. But the result was that the spreadsheet disappeared
off my screen. I tried to re-open it, thinking I had inadvertently
closed it, but got the message that it was already open. Yet the only
window visible was the "Book 1" spreadsheet that appears on Excel
startup. I looked in the "Window" drop-down menu at the top of the page
which lists all open files, but only "Book 1" was listed -- there was
n...How to find a message
What is the easiest way to search an entire exchange server for a particular
message so that it can be deleted from all mailboxes at once?
Seems like Exmerge can do what you ask.
"Marty S" <MartyS@discussions.microsoft.com> wrote in message
> What is the easiest way to search an entire exchange server for a
> message so that it can be deleted from all mailboxes at once?
check this article out;
HOW TO: Remove a Virus-Infected Message from Mailboxes by Using the
h...where do I find the current user in crystal reports
topic says everything :-)
Many Places Depending what you want to know?
Active Directory, Deployment Manger, Web Cleint Top Left=20
Corner, OUTLOOK, Settings-Business Units-Users...
>topic says everything :-)
...Finding old email
I have a new computer and can't find my old email. I had
my old hard drive put on my new one as a separate archived
drive, but don't know what folder my email was stored in.
I used outlook express and am now using outlook. Does
anyone know what "*." file i can search for to find my
On Mon, 10 May 2004 12:52:58 -0700, "Kim" <email@example.com> wrote:
>I have a new computer and can't find my old email. I had
>my old hard drive put on my new one as a separate archived
>drive, but don't know what folder my email was stored in.
&g...Need to find directions to build a family genogram
Psychologist has me displaying my family connections by use of a 'genogram'
(gen-o-gram)? I want more directions so I may complete this before my next
appointment. I need all of the help I can get. It is using boxes and
circles and triangles for specific family relationships and they are also
Thanks for any help
Here is a good example of how to do it... The components are displayed on the next
page. This is a really good URL for what you are trying to do.
Mary Sauer MSFT MVP
http://office.m...Wildcard in the Replace function
This is a general question on the replace function. In the Find/Replace
dialog box, you can use wildcards to find text/formulas. There is not the
same capability to use it in the replace function. I would like the wildcard
to act as a placeholder. When I do the replace, I like to include some of the
text string to ensure that the correct part of the formula is changed.
So here is an example. The cell references are in brackets.
'=CustList$B14(B4) =CustList$C14 (C4) =CustList$D14 (D4)
In the replace part:
The "*" would leave the current column ...Find Now returns "no items found" in a public folder when it should find something
I have an SBS 2003 server running with Outlook 2003 clients. In one
particular public folder if the user selects this folder in Outlook and uses
the "find" button, types in the criteria in the "look for" field and clicks
the "find now" button - Outlook does not find anything (there things to be
found) and comes up with a "no items found" message. If the user uses
advanced find from the "options" drop down menu - then the search works!
But when the user trys this seach in other public folders (with the relevant
search criteria) - it works....Capitalisation in Find and Replace operations
Hi, I'm just writing because I have noticed an odd thing that Word does when
doing a "find and replace", and was wondering whether anyone know the reason
or a fix for it. Basically, I have found that if you ask Word to replace the
word "foo" (please excuse the word!) with the word "test", if the original
word is uppercase as in "FOO", Word will replace it with "TEST". Similarly,
if the original word is capitalised "Foo", Word will replace it with "Test",
even if you want it to replace it with "test"...need to find out what to do
to whom it may concern
i bought this excel version three
at a tag sale and it has never beed open and i can't use
it on my cumpter because it is to old i would like to know
if you take them back if they have not been open
Only if your tag sale gives refunds.
No one else will/should be responsible.
Gord Dibben Excel MVP
On Wed, 6 Oct 2004 16:26:35 -0700, "firstname.lastname@example.org"
> to whom it may concern
> i bo...Delete all attachments in an email in one operation
How do I delete all attachments in an email in one operation, without having
to delete attachments one by one in Outlook 2003? I have emails with many
Hold down your shift key, highlight the first attachment, and use your arrow
key to highlight them all, then click on the delete key or right-click and
scroll to delete.
"LillA" <LillA@discussions.microsoft.com> wrote in message
> How do I delete all attachments in an email in one operation, without
>...Find & replace different years (part of the date)in a column
I have the various dates on which our staff have joined the organisation. I
need a column that would convert all the year part of the date into the
current year so that the increment date could be traced. Single command or
macro would do. I need this feature in Excel sheet, preferably. However, if
there is any other option, i would like to pursue it as well. Writing of code
should be avoided.
OR handling blanks.
Jacob (MVP - Excel)
"krishna K" wrote:
> ...find first data in a row
I have a spreadsheet which contains a tree-structure (contents of
cel B1 : dir 1
cel C2 : subdir 2a
cel D3 : filename 3a
cel D4 : filename 3b
cel C5 : subdir 2b
Which formula should I use, in unused column A, to decide the "level
of the row.
I used the following formula
in cel A1 and copied down.
Is there a better one. (The level of nesting directories is now to
limited, concatenation takes only 30 arguments, if I want to make th
maximum level higher, I ha...Finding the largest size in a group
I have a query that I am trying to find the largest number in a grouping
within a list . My data is as follows
What I need is to be able to find the largest of the threein this group and
then move on to the next group and do the same thing. Any help would be
Consider having one information per field, rather than 'encoding' the
information. Sure, sure, sure, the management probably like 'encoding' their
'product number' and so on, but that does not mean your database SHOULD do
the same. As exam...Large Operation Error
Excel 2007 (file converted from previous version of Excel through Save As and
also incorporates data from another spreadsheet in a previous version of
I have been working with a spreadsheet that has developed a major error in
one worksheet after I have shut my computer down and restarted it. Once I
access the file again, every time I try to delete a row or column from the
worksheet, I get a "large operation" error message saying that "The operation
you are about to perform affects a large number of cells and may take a
significant amount of time to complete...replace cell value
how to replace sheet1. cell a1 with shhet2 cell a1 if sheet 2 cell a2
matches sheet1 cell a2
Run this small macro:
If Sheets("Sheet1").Range("A2").Value = Sheets("Sheet2").Range("A2").Value
Sheets("Sheet1").Range("A1").Value = Sheets("Sheet2").Range("A1").Value
Gary''s Student - gsnu200909
> how to replace sheet1. cell a1 with shhet2 cell a1 if sheet 2 cell a2
> matches sheet1 cell a2