Formatting copied cells
How can I format a cell to not display anything when the cell that it is
copied from doesnt have any values in it?
Hi Brett, I think you are are referring to a formula here?
If you have the formula "=A2" in a cell, it will show the value in A2. If
A2 is empty, it shows a 0, or even #N/A or something nasty like that. If you
change the formula to read "=IF(A2="","",A2)", it will only show a value if
there is a value in A2.
I hope this is what you were after?
> How can I format a cell to not display anything when the ce...Using Publisher for long reports
I write long reports (50 pages) in which layout and style are very important.
I'm thinking of switching from Word to Publisher since Word's management of
pictures and layout drives me wild.
Can anyone advise me if Publisher might be the right choice?
Does anyone have some long document templates they could show me?
It sounds like Publisher would be perfect for you since you indication that
the layout is important. I can't help with a sample tho because (1) the
longest I've done is about 24 pages and (2) my newsletters contain personal
contact information and...Adobe FLASH & AI cannot COPY...
my client have 2 work stations, both are winxp 64bit SP2...and CS4...all
official licensed products with latest updates...
COPY function fails always...such problem occurs since last week...after
reinstallation of OS...due to other problem of ADOBE CS$...
ctrl+C...menu/edit/copy...right click copy...
i've checked the clipboard...but only img or txt copied last time...
asked ADOBE...the advised to remove settings file of these two software...
AI...failed after few minutes...
FLASH...failed after about 30 to 40 mins...
concurrently...copy function...how to convert to metric system in visio 2003?
how to convert to metric system in visio 2003?
On Tue, 3 Mar 2009 00:00:00 -0800, alsari
>how to convert to metric system in visio 2003?
Don't be reluctant to tell us what you want to do. We can only guess
Do you want to use metric rather that imperial measurement templates
Do you want to convert current diagrams to metric?
Do you just want to show measurements in metric units?
Metric templates and stencils may not have been installed on your
Use menu Tools -> Options to set the default measurement t...Outlook 2003 Outlook Today Problem
I installed Office 2003 Standard over top of Office 2000
Professional. I'm running Windows XP Home Edition, Outlook
2003 will not let me permanently customize Outlook Today.
When I click on customize it presents the menus but is
unable to find the graphics such as Winter, Summer, etc.
It lets me select summer for instance and when I save the
changes I get the summer scheme. But, when I exit Outlook
and return my saved preferences are gone. There also
appears to be graphic place holders on the Outlook Today
screen, no 'x's just blank little squares. In the black
date bar o...How do I open doc's from Publisher 2000 when I am using Pub 2003?
I recently purchased Publisher 2003 and can't seem to edit any document from
a previous version.
Are you running Norton AV? Try disabling NAV Script Blocking
Click Options. If a menu appears when you click Options, then click
NortonAntiVirus. The Norton AntiVirus Options
dialog box appears.
Click Script Blocking.
Uncheck Enable Script Blocking (recommended).
Restart the computer if prompted to do so.
MVP Microsoft [Publisher]
"GAR" <GAR@discussions.microsoft.com> wrote in message
news:01222D01-7A00-4...REstoring a mail sotre to a newly installed exchange 2003
I have a windows SBS 2003 server installed with a couple of mailboxes on it.
I backed up the mail store then decided to reinstall the OS. The reason to
do this was to partition the disk differently.
So I installed the OS from scratch, and now I need to restore my mail store
backup done using ntbackup.
Should I recreate the old users on my SBS2003 system or should I just
restore the mail store on top of the exisiting mailstore created by the fresh
installtion of the OS.
I didn't backup anything else but the mailstore.
The newly installed server uses the same domain name as the ol...Mail as web page
I want to send an advertising mail shot that looks like a web page.
What is the best way to achieve this?
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is
confidential and may be the subject of legal, professional or other
privilege. It is intended for the named addressee only and may not
be disclosed to any other parties without the prior permission of
Fight Spam! Join EuroCAUCE: http://www.euro.cauce.org/
...Page break in publisher to change from portraite to landscape
I am trying to change one page from portrate to landscape without effecting
the rest of the pages, but each time i try it effects all the pages. I know
in word you can select page break. Is there something similar in publisher
as i am unable to find this?
Message posted via OfficeKB.com
Pub 2000 here and for me to do what you want I must leave the page in
question as portrait and turn the text and images 90�.
"chedd via OfficeKB.com" <u18187@uwe> wrote in message
news:75f1cac2d1fca@...Help Microsoft Office 2003
After now using Microsoft Office 2003 for about 3 months now, have suddenly
noticed that my email messages have just started showing strange symbols for
certain punctuation. This does not show as I type... but the recipent sees
these symbols when the message is received. I can see it when they reply
The strange symbols show for the apostrophe and sometimes for the
exclaimation. I do not recognize the symbols.
I do not have caps lock on, do have number lock on. None of the symbols show
on my keys.
it's caused by character encoding. What email client and...Exchange 2003 SBS Attachment filtering in admin
I have set up SBS 2003 / Exchange on our server some time ago. I have been
trying to find the location to add an additional attachment to the exclude
list on incoming mail. (Attachment filtering). I have looked for some time
and cannot find the UI to do this in the system manager.
Could someone point this location out to me?
"D S" <email@example.com> wrote in message
> I have set up SBS 2003 / Exchange on our server some time ago. I have
> been trying to find the location to a...Free ASP.NET MVC paging component
I wrote a free asp.net mvc paging component (should it be called "control"?)
called MvcPager, it supports 3 paging mode:standard url paging,default Ajax
paging and jQuery Ajax paging. The paging implementation was inspired by
Scottgu's PagedList<T> idea. You can view online demo and download it from
http://en.webdiyer.com in case you're interested for this component! Hope you
can find it's helpful!
I have a solution with multiple projects. On my LOCAL computer in Visual Studio 2008, I
can choose a website, mouse right click, choose Publish and it publishes to my LOCAL
c:\temp\webSiteName directory. It works great. I then use a bat to zip and copy the
published project to the remote web server. (I am doing it this way instead of directly
publishing the project to the website because it takes forever to copy the VERY BIG
published project if it is not zipped.)
I would like to NOT to have to "choose a website, mouse right click, choose Publish" and
do this as pa...Outlook 2003 from SBS2003
After we upgraded our server to SBS2003 over the weekend
and as a part of this rollout all our client machines
running XP and Office XP were upgraded to the Outlook
2003 client. Since this has occured no one can use word
2002 (Office XP) as the default Message editor. It
appears that Outlook 2003 has changed the default setting
for saying Microsoft Word edit to now say Office Word
2003 which by the way is greyed out. Probably due to the
fact that none of the clients have office 2003 installed
on them on the new Outlook 2003 that occured during this
Any idea's wo...Uprage to 2003 from 2000
Over the weekend I have installed an exchange 2003 server within the same
domain as an exchange 2000 server.
All is going well except this morning I am getting alot of reports from
users that they're emails are bouncing back with a "mailbox over the size
I normally hear of these all the time, but I'm finding that this morning
I've gotten a lot of complaints.
When I look at the users mailbox in ESM, for some reason alot of them are
much larger than the size limit that they have on their mailboxes. For
instance, one user has a limit of 350000 yet...How do I make a single pdf page out of 4 publisher pages?
I would like to be able to send this newletter in pdf format by email. The
people who receive it would like to scroll through the 4 pages. So far all I
have been able to do is make a pdf out of each page and attach ~ as an
attachement. They have to open each attachment to see the next page. Any
As you save to pdf look for a statement that says, "Append to existing
file". This way all four pages will be in one file.
Don - Publisher 2000�
"Cody" <Cody@discussions.microsoft.com> wrote in message
news:0855587A-6DA5-410...Data Loss in Publisher
I run a W2k network in a school. I have Office Group Policies in place
forcing the default save location for Publisher documents (Office XP version)
to the pupil's home folders. All my PCs are identical (ghost images).
Pupils have roaming profiles (some mandatory).
Some users save work in Publisher and the next time they log on to the
network and open the saved file, it's contents have gone! There is nothing
exceptional about the affected users' user accounts and they have a mixture
of mandatory and roaming profiles.
Has anyone come across this problem before?
Than...Running 2 Versions of Publisher
I want to install and try the Publisher 2007 trial version. I currently have
Pub 2002 on my machine. Can I install both versions? Or does 2007 screw up
2002? Or can I install 2007 on another HD on my system w/out touching my 2002
install? I DO NOT want to screw up my 2002 version - I have many
files/clients who use it and we all know how stupid Pub is about reading
files made in different versions. It would be very nice if the two could run
side-by-side, and you could have both installed and running so you could
choose between them. I don't suppose that's possible is it?Dawn
I ...Make outlook 2003 start in favorites
I am trying to get my outlook 2003 to startup the left pane in th
Favorites tab, instead of the Mail tab. It is annoying for me to hav
to switch tabs every time i start it up, as I prefer to be in m
How can this be done
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...MSN email acc in Outlook 2003
I'm a Hotmail Plus user but it seemed that I can't use the Outlook 2003 to
retrieve my emails.
The error: Task 'MSN: Folder: Inbox Synchroning headers.' reported error
(0x800CCF4): 'An unknown error has occured. Please save any existing work and
restart the program.'
This error occurs only with MSN email account. The error still occurs even
though I removed and added the account again. I even restart Outlook and it
still the same thing. I tried adding my msn email account at work using
Outlook 2003. It works there but apparently, not at home. I tried on...MX question on Exchange 2003
When I try to send mail to any user in the domain graphics.ucsd.edu the mail
can not be delivered because there first MX record that points to
22.214.171.124 doesn't have port 25 open for mail.
So my server tries only that server for tree days then it gives up.
First of all, why doesn't my server try any other server with lover
And what is the reason to stop port 25 on their first MX server?
I have an Exchange 2003 server with sp1 running on a windows 2003 server
> When I try to send mail to any user in the domain graphics.ucsd.edu
> the mail can not b...Exchange 2003 Mail between servers stops after a few days
I have an odd situation where mail destined for a different administrative
group in the same domain stops after a few days; a restart of the server
where mails are queing clears the problem.
The destination admin group is attached via a connector (smtp), and it's
this connector that goes into a retry state under fault conditions. A
bridgehead at either end is used, although looking at message tracking
suggests the bridge-heads are not being used.
Local mail delivery is unaffected, only mail to the remote admin group is
There are firewalls involved: the sites are...Exchange 2003 migration #4
Can you please advise me few steps or provide some links to my problem. (I
am inexperienced in dealing with exchange :)). I am running MS Exchange
2003 on SBS 2003. I need to move the Exchange to different server (windows
2003 std in the same domain, I have also bought new Exchange 2003 for it)
and then get rid of the source server at all. What is the best approach to
perform this migration?
Thank you very much in advance,
The move mailbox wizard will allow you to move mailboxes between servers.
The best approach is to bring the new box up in the same Exchange org a...line breaks in Outlook 2003
Why does Outlook 2003 remove "extra line breaks" in email msgs? It's quite
annoying b/c I belong to several listservs and some of them send digests
that require you to get those "extra line breaks" back.
Ex of orig:
11. Job opening: Desktop Specialist- Chicago IL 12. Monitors to donate 13.
Moving - any suggestions 14. Reply to... wimming with the dolphins...
How do you read that? I have to click the remove line breaks button EVERY
SINGLE TIME. I can't find a setting to stop this. This was never an issue
remove "sm...HtmlHelp doesn't shoe the right page
I have a CDialog based application and i called
in my WinHelp method. I checked the helpFilePath contains the right path,
"c:\myapp\hlp\help.chm" and the dwData contains a right Help ID. I checked
..ali file, it contains correct information, like
HID_CALL = Directory\Call.htm
and in my hlp directory, it has a folder called Directory and has Call.htm.
However, the HtmlHelp always return NULL. Would you please give me any ideas
why the help doesn...