MINUS SIGNS REMOVAL
Greetings. I am using EXCEL 2003, and I am still struggling. I have a
column containing numbers, and some of the numbers (after calculations from
previous columns) have minus signs in front of them (e.g., 8, 6, -7, 4, -9,
3, -1, etc). I want to remove the minus signs from the numbers, and sort the
numbers so that is what they are -- just numbers. How do I do this? Thanks.
Select the range
what: - (minus)
with: (leave blank)
If you really want to keep the values as-is, you can use a helper column of
cells with formulas like:
and drag down.
then...Setting in Outlook 2007
I have Outlook 2007 with all updates, how do I change the settings so
attachments, web addresses or inserted pictures are not removed
Thanks for any help
Attacments removed? - Uninstall your anti virus application
Web addresses - In internet options ensure outlook is set as default mail
"Daniel" <firstname.lastname@example.org> wrote in message
> I have Outlook 2007 with all updates, how do I change the settings so
> attachments, web addresses or inserted pictures are not removed...email blocked as phishing by MS Mail
We send out email campaigns to our customers that request email from
us notifying them of specials/sales/... We are a ligitimate company
and these emails are only sent to customers that request these emails.
A customer has a Vista system and is using Microsoft Mail to read his
email messages. He reports that email he gets from us is blocked by
the mail reader and he receives the following message "Windows Mail
thinks this email is suspicious and has blocked it" and has the option
to read the mail anyway.
My questions are
- why does our email get flagged as phishing email?
- ...Duplicate entries in Outlook 2003
For some reason all my calendar entries in Outlook seem to either duplicated
or are showing twice. Is there an easy way I can run a clean-up?
"Trent SC" <email@example.com> wrote in message
> For some reason all my calendar entries in Outlook seem to either
> duplicated or are showing twice. Is there an easy way I can run a
If a set of duplicates was created by a single action (like, for instance,
syncing with a PDA) then the LastModificationTime values for the duplicates
should all b...= sign on toolbar
I just recenttly was upgraded to Excel 2002. I use to have an = sign in the
toolbar...now I have an fx function. Is there any way to get my = sign back
(it was very convienient to just click = and then go the page I neede)
Gone as of 2002. No work-arounds.
You can move the = sign to your Toolbar but it does not bring up the Function
Wizard so is useless except for not having to type the = sign. Wheeee!!
Was not a popular move on the developers' part.
Perhaps re-structured in the next version after 2003.
Gord Dibben Excel MVP
On Mon, 28 Feb 2005 07:49:04 -0800, "ge...Removing The Sales for Outlook Client
How I can remove The Sales for Outlook Client? I try from Adding/Remove
Programs but it removed inadequately and some components remained by there.
Now I cann't installer the aplication again.
How I can do it?
Thanks for all!
Hi Yexy, you might want to try the following;
1) Make sure there are no SQL Server or Microsoft CRM folders in ‘Program
Files’ folder (delete if any)
2) There are no reg entries for MSCRM or SQL Server (use RegEdit, navigate
3) Search for a file called MSCRM.pst anywhere on your hard drive. Delete or ...How do I disable "Customize" on MS Publisher?
PUB11.ADM files is missing the capability to use "Disable Items in User
interface" which in include "Predefined" and "Custom". I did modify the
PUB11.ADM files but the application itself doesn't recognize the chamges. So
my question is how do I disable those feature on MS Publisher?
I have the same problem now, does anyone know a solution for this problem or
can i make a custom adm file...?
> PUB11.ADM files is missing the capability to use "Disable Items in User
> interface" which in include &quo...Outlook 2007
I would like to create a rule that automatically deletes SPAM where the
"Display Name" is phony. I get a ton of this stuff and the Outlook 2007 SPAM
filter properly puts it into the "Junk E-mail" folder but I would like to
have it deleted so that I don't have to go through it every day. I have
tried a lot of variations on the rules "Where my name is/is not in the To
box", "With specific words in the recipient's address." without success.
Any ideas on how to make this work would be greatly appreciated.
"Joel Elias" <jel...Outlook 2010 beta duplicating inbound mail
I've started using Outlook 2010 Beta. It has been downloading the same
messages over and over again on all 4 accounts. In fact one account has
re-downloaded the Outlook Test Message 52 times and that is the ONLY message
in that account right now. I've deleted it from the server, but I don't WANT
to delete the messages from the server.
> I've started using Outlook 2010 Beta. It has been downloading the same
> messages over and over again on all 4 accounts. In fact one account has
> re-download...MS Exchange and external mail relay
In our organization we are planning if moving from Linux (postfix) to MS
We plan to implement Postfix (in DMZ zone) as a mail relay for Exchange
server (in LAN).We have about 400 users on the same external domain like
The trick is that about 100 of users only need mail address (not also a
domain account), so we're thinking if it is possible to create 300 of our
users of @comany.com domain on Exchange server, all other users that need
only company mail (also @comapany.com) will have mailboxes on mail relay
(postfix), not on Exchange server.
Since it...Outlook Rules Wizard #2
I can't seem to find the syntax rules for Rules Wizard
(Outlook 98), e.g. is it case sensitive? can I use the *
wildcard? I'm using it to block junkmail and given the
volume, would like to streamline the entries. Thanks for
...Outlook 2003 and views!
Say I want to remove the FLAG bar of RECEIVED (the one
where you can sort by) bar from my respective folders -
that I have created, is there a way to do it and remove it
from ALL my folders, rather than me doing one folder at a
As always, thanks in advance
...Old MS Mail 3.0 support
I am trying to find a way to support the old Microsoft
mail postoffice. I have several cusotmers on small local
LAn's using this with Outlook 97. If I convert/upgrade
them to Office XP it continues to support the MS Mail
Postoffice. However, a New install does not have this
support. Anyone know how to get Office XP/2003 to support
the old Microsoft Mail Postoffice?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
witho...Sign in email address problem
How do I change my sign in email address. I have change passport to my
correct email address and updated my pass word but Money 2004 does not
remember the new address or password. Thanks for your help. Hank
I'd go into File|Password Manager, delete the Passport, then re-add it with
the new Passport sign-in name.
"Shorty" <firstname.lastname@example.org> wrote in message
> How do I change my sign in email address. I have change passport to my
> correct email address and updated my pass word but Money 2004 does not
> remember the new address...how do i count time numbers whit a negativ sign ( ex -19 hours, 25
how do i count time numbers whit a negativ sign ( ex
-19 hours, 25 min
plus -22h,32 minuts
How is the time stored, as text? If so, can you give the precise format?
(remove nothere from the email address if mailing direct)
"rabbeer" <email@example.com> wrote in message
> how do i count time numbers whit a negativ sign ( ex
> -19 hours, 25 min
> plus -22h,32 minuts
...Outlook message rules #2
I have a pop account with an ISP. From this account I have
several email alias's, this allows me to have several
email address's for different poeple in the household. In
the past I have used Outlook Express and configured the
message rules so that only that persons email will be
downloaded from the server. But the option "Do not
Download it from the server" is not available in Outlook.
Why can I configure OE but not Outlook?
You CAN change the settings -- it's just "different" (and
not as friendly as OE (surprise!))
In Outlook (I'm...how to eliminate ####sign and shortcut signs..
ie1: For instance keyed in 11111111111 in the cell, endup displaying
Qns: How to display my desired data which is '11111111111'.
ie2: Intend to key '111,112,113....120' on cell, given 'pre-adjusted' column
and numbers continue on next row below and next. Given '111,112....120' taken
up 3rows and able to fill ideally,without the outcome shown ###### sign.
'Resize' column/row adviced, i just wanted the numbers to fill in my
Preformat that cell as Text or start your entry with a leading apostrophe:
When I create a new email message, hit the "To" button and select my contact
list, I get the Full Name. I would like to get the list Last Name, First
Name which is how my "File As" column is setup. Is there a way to do this?
...MS Access 2007 User permissions
How can I restrict some users accessing specific forms/tables? Since 2007
removed user level security; how can 2007 handle this?
It cannot be done for tables. For forms you can roll your own security by
integrating with Windows login username. But since the users can get to the
table that would store this information, it isn't 100% foolproof. The
alternative is to code each form with specific permissions for each user.
To get the Windows login credentials, see:
Arvin Meyer, MCP, MVP
http://www.acces...outlook express backups
how is backup for emails done with outlook express. I
have been trying to copy it to a CD however the .bdx files
cannor be opened with outlook, the error msg that says the
action must be defined before it's use... do i need a
third party software to do the back up?
Outlook express uses *.dbx files for storage.
OE Backup, free backup utility
For other Outlook Express information:
Nikki Peterson [MVP - Outlook]
"dre" <firstname.lastname@example.org> wrote in message
news:007f01c3dc64$22c7ddf0...SignedXml gives false negatives when using namespaces in signed xm
It seems that digitally signing XML documents using the SignedXml class has
a bug - or at least a behavior I cannot explain.
The problem occurs when I sign XML documents containing namespace prefixes
and namespace references and then validate it. The validation always fails
(returns false) in this case. When I remove the namespace prefixes and
namespace references from the XML, signing and validating works fine.
It seems that the problem has been recognized in .NET framework 1.1 (see
http://support.microsoft.com/kb/888999/en-us), however I am using .NET 2.0,
and the problem...Microsoft Outlook has stopped working
I am running Outlook 2007 SP1 and Vista Ultimate SP1. From time to time,
Outlook crashes with the message "Microsoft Outlook has stopped working". It
then closes and re-opens itself. I am unable to create an event to cause
this to happen, it does so randomly, probably on average once a day.
Any advice as to how I fix this.
Thanks in advance.
at first I would check, if your Outlook works in a "safe" mode without any
This "safe mode" will disable all addins of Outoook.
Command-line switches => use "/safe"
...CRM Sales for Outlook 12-10-03
we installed crm on a domain and installed crm sales for
outlook on a few clients. We then created a new domain,
reinstalled crm on the server and now we can't install
crm sales for outlook on the desktops. I am able to
remove crm sales for outlook on the desktops but when I
go to reinstall, the SQL desktop engine doesn't install.
If we completly reinstall windows, we are able to isntall
crm sales for outlook.
deinstall of the client leaves a SQL folder on the client
I cant remember the detailed path now, but you will find it somewhere
in the windows explore...Using Outlook 2007, where are my old emails stored in Outlook 2003?
I have bought a new computer which has Outlook 2007. My previous computer
uses Outlook 2003. I would like to keep and possibly 'transfer' the old
(stored) emails from my previous computer onto my new computer so that if
need be, I can view them again.
Where should I look in the 2003 version and which file should I copy?
I think I recall being told several years ago that Outlook stores Contacts
in a file ending with .pst but I am not sure about the extension of the file
which stores the emails. I do not necessarily want to replace my current
(Outlook 2007) emails and folders wit...Is Outlook CRM 3.0 PlugIn a joke or is it my failure???
after very bad experience with CRM 1.2 I thought I would give CRM 3.0 a
second chance (and they will get a third one too). My first impression was:
Why are the Icons in the tree not the same as they are in the webfrontend!
Okay after this I started working. I thought that email tracking would be
great for me. So I started to add my email (I write them in Outlook) to the
They were automatically added to the history - great!
I got the response (also added to the history) and answered. So from my
part, I think I am done with this. But CRM still has a new activity in my