How do a get a negitve number to be bracketted rather than showing the
"-" sign. I'm also using thousand seperators.
Embalmer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17907
View this thread: http://www.excelforum.com/showthread.php?threadid=497197
<Format> <Cells> <Number> tab,
And click on "Number' in the left window,
And on the right side you'll see a choice of 4 or 5 negative formats,
And also you can clic...Formula: Date plus 3 months
Hiya, I have a date in cell A1 and I want to know a formula which will
calculate this date minus 3 months, in cell A2.
I've tried a simple "=A1-3month" but this doesn't work.
Followup to newsgroup only please.
"Carly" <Carly@discussions.microsoft.com> skrev i en meddelelse
> Hiya, I have a date in cell A1 and I want to know a formula which will
> calculate this date minus 3 months, in...CRM 3.0
I've just received the 3.0 beta version. Does anyone know of any training
materials or detailed demos that are available for this version? If anyone
has created their own would you be willing to share?
> I've just received the 3.0 beta version. Does anyone know of any
> training materials or detailed demos that are available for this
> version? If anyone has created their own would you be willing to
Microsoft CRM 3.0 Online Help
http://www.microsoft.com/d...CRM 3.0 Installation Verification Task Error
In the installation procedure, in the part of the verification task, before
de copy of file is made. I'm having some trouble because it says "Setup
detected a version mismatch between the specified database and the current
product." this is in the Verification of Microsoft SQL Server part, so the
wizard disables the "Next" button.
Somebody could help me?
What version of CRM is this? It sounds like CRM 1.2 but please verify.
Are you connecting to an existing set of databases, or is it a fresh install
with new databases?
"Ricardo A...delegate Control #3
I would like to rollout delegate control over our domain could any poin tme
to a good website that explains what each custom control does?
...3 questions about ActiveX settings?
I'm using WinXP-pro and Outlook2003. When I see a certain (reputable)
eNewsletter every day in the long list of incoming emails, I click on this
one to make it full sized so I can read the headlines. But before Outlook
brings it up, it warns...
(yellow exclamation point)"Your current security settings prohibit running
ActiveX controls on this page. As a result, the page may not display
It used to not do this, two things have happened recently...first, I've
downloaded all the Win patches, and secondly, the newscompany seemd to have
upgraded their newslett...Backing up and reimporting accounts
Is there a way to backup the mail accounts info in Outlook 2000? I need to
reformat my harddrive and want to make installation as easy as possible. All
I want to backup and restore are the ACCOUNT info. My system is running SO
SLOW (no virus, no spyware etc... that I have been able to find) so I don't
want to move anything else into my clean registry except account info.
If running Outlook 2000 in Internet Mail Only mode, you can export your
account information. Look under the File menu. If running in Corporate or
Workgroup mode, it is not so easy. You can export ...when exporting a budget to excel, the order should be by account
It looks like the default sort order when exporting to Excel is by Account
Index. This is meaningless to users. The sort order when exporting a budget
to excel should be the account number
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Busine...Money 2002 Changing Investment to Savings account
Is there any way to do this? Am I missing the obvious?
...Automatically change list values #3
Thanks, that works perfectly for me
DKerr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1308
View this thread: http://www.excelforum.com/showthread.php?threadid=27040
...Account and Contact on One Opportunity
My sales team needs to know both who the Account is as well as who the
primary Contact is for an Opportunity. Since there doesn't appear to be a way
to have two fields on the Opportunity form to handle this, what is the
recommended work-around? I can think of two:
1. Add an attribute and text box for "Account Name" to Opportunity that's
filled in when Opportunity converted from Lead.
2. Write code to dynamically look up Account Name from selected Contact on
Opportunity form whenever it's displayed.
3. Just fill in the Account name in the "Topic" field when...How to enable Custom text, date and number in POS 2009
How do I enabel Csotom Text, Date and Number in POS 2009?
This is a multi-part message in MIME format.
The steps a fairly easy:
1.. In manager view, go to Settings -> Store Settings -> Options
2.. Click on the Customer entry in the list
3.. Then under the Custom field section, you have to add a caption to =
those fields you want enabled.
Then when you go back to edit a customer, you will be able to inp...Multiple Account Signatures
I am using Outlook 2003. I have two email accounts set up (1
exchange, 1 pop3).
I have a rule in place to automatically put any emails coming into the
pop acct. into a separate folder.
When sending messages, the exchange account is defaulted as the
outgoing address to send from.
I have the need to attach a signature to any email going out of the
pop3 account. I have the signature set up and associated with new
messages on the pop3 acct.
When I click New Message, I click to change the account used to the
pop3 and the signature is not inserted. If I change the setting to
put the signature...Create custom Outlook 2003 calendar view to show subject and body
How do I create a custom calendar view to show a table, sorted by date then time, of events with subject, body of the event and duration?
Any help will be appreciated.
See if this gets you started:
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exch...Associate An Account
After balancing a credit card account and clicking on next, I get a dialogue
box that states 'Balanced' and gives me a choise to 'Pay Bill Now.' After
selecting 'Pay Bill Now', the software requests an account selected.
My question is, is there a way to associate an account from which the funds
should come for each credit card and only change it on an exception basis?
I use Windows XP and Money 2004.
...How can i create custom label sizes in Publisher 2000?
We'd like to use Publisher 2000 to print package labels, 6 per page, 2 7/8"x5
We hope it will be less difficult to lay out than in Word.
See the following links:
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Mumm's Sprouting Seeds" <Mumm's Sprouting Seeds@discussi...Change Live account associated with Outlook calendar published onl
I needed to publish a co-worker's calendar online so an external vendor could
view it (we're using Outlook 2007). She wasn't around, so I just used my Live
account when prompted (stupid, I know). Now she gets prompted several times a
day to log in to my Live account.
I unpublished the calendar and re-published, but it doesn't prompt for a
Live account again; does anyone know how I can change the Live account
associated with this published calendar?
Delete it from Tools, Accounts, published calendars.
Diane Poremsky [MVP - Outlook]
Outlo...Account does not show up in Budget
I am trying to set up a budget but Money will not allow me to select my
Banking account for spend tracking purposes. The account settings page has
the box checked for using the account for budgeting purposes but it still
won't show up in the Budget accounts. Any suggestions?
What version? If 2005/6, Essential Budget or Advanced Budget? What are you
trying to do when "Money will not allow" you to select the account? What
does it say/do?
"Flats" <Flats@discussions.microsoft.com> wrote in message
news:696694B8-310D-4DB8-8CAD-917CECB9815B@mi...onChange event and custom aspx
I have several custom fields in the opportunity object that I want to
summarize and put the value in another field. I have written a java
script for this (trigged in onChange event in a pick list field) and it
worked but suddenly it stopped to work. No scripts are trigged in the
opportunity object (not even an alert...). Why? Scripts works just fine
in other objects in CRM.
My second choice was to add a menu item in the ISV.config and redirect
to an aspx page. Can I use the script that I wrote for the onChange
event? Can someone give me an simple sample on how I should do? I do
not wa...Putting Products in a Pick List Custom Field
Is it possible to add a Picklist ( drop down box ) to a custom form, which
has a list of products?
Sorry, I don't mean Picklist I mean select box with the magnifying glass
next to it so you can choose the products..
"Luke Baines" <email@example.com> wrote in message
> Is it possible to add a Picklist ( drop down box ) to a custom form, which
> has a list of products?
...Customer Relationship Management (CRM) Guide 09-01-06
Customer Relationship Management (CRM) Guide
CRM Basics,CRM Objectives,CRM Types :: Operational CRM , Analytical CRM
,Collaborative CRM, CRM Implementation ,CRM Technical Functionalities
,Popular CRM's :: SugarCRM ,vTiger CRM , Daffodil CRM ,Future of CRM
...custom views-no available values in 'edit filter criteria'
i am trying to create a custom view that is based on one of the values in a
picklist within a custom field.
when i go into edit filter criteria, i select the field i want, choose
equals and then when i get to 'enter value' i have no options in the
'available values' area.
I gather i should have the picklist values as available values to choose from?
I tested it using another standard field; marital status then i have options
in the available values area. but i had added another 2 options to the
standard picklist-de-facto and separated; which do not appear in va...Marketing in CRM 3.0
I am loking for a full blown marketing add-on to CRM 3.0... any
Microsoft CRM 3.0 ships with a Marketing Module that has campaigns, quick
campains and related features. What is the functionality you are looking
Manisha Powar (Madhusudanan)
Microsoft Dynamics - CRM
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. � 2005 Microsoft Corporation. All rights
"mw" <firstname.lastname@example.org> wrote in message
I have moved mailboxes from an exchange 5.5 to an exchange
2003 server. All permissions are gone (ie. sally can't
access billy's inbox anymore). If I try to add sally back
to billy's inbox it will not allow me, but I can add a
user that was created after active directory was created.
Any suggestions or comment.
...Comma separator for custom Currency
Intent to display:
100000 has to be displayed as Rs. 1,00,000.00
10000000 has to be displayed as Rs. 1,00,00,000.00
0 has to be displayed as Rs. -
David McRitchie, Tushar Mehta and others wrote the format as given
Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0
Rupees without Rs. notation