Feb 28,2008 ---> 2008-2-28
Feb 1,2008 ---> 2008-2-1
"����" <firstname.lastname@example.org> wrote in message
> Feb 28,2008 ---> 2008-2-28
> Feb 1,2008 ---> 2008-2-1
See your other post
> Feb 28,2008 ---> 2008-2-28
> Feb 1,2008 ---> 2008-2-1
Highlight the cell, right click in the mouse, cell format, custom format and
> Fe...Find and replace 03-04-10
I'm trying to scan a field in one of my tables and find a specific character
and remove it. However, the character is a " so I'm having difficulty. The
field I speak of of contains the sizes of our material so the values look
1/3" and so on.
How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.
Create a query, and in the Criteria row under the problem field, enter:
Allen Browne - ...Formula needed 01-22-10
I need a formula that will look in one column range for a certain value and
for another value in another column range and when they are both found in the
same row, will count the number of occurances. Help!!!!
> I need a formula that will look in one column range for a certain value and
> for another value in another column range and when they are both found in the
> same row, will count the number of occurances. Help!!!!
Omit the "values to be summed".
=SUMPRODUCT(--(A2...How do I delete the test documents in my recent documents?
I took the test for the excel spreadsheets and now they are in my recent
documents and I want to know how to remove them, can you help me?
Go into Options and set your MRU list to zero.
Close Excel and restart.
Reset the list to whatever you like.
Gord Dibben MS Excel MVP
On Sat, 13 Feb 2010 11:17:01 -0800, mrjack
>I took the test for the excel spreadsheets and now they are in my recent
>documents and I want to know how to remove them, can you help me?
...SendTo PDF Not Working on GP 10
I upgraded a client from GP 8.0 to GP 10.0. Since the ugprade, they are
unable to use the SendTo PDF option from within GP. We have tried
reinstalling Adobe and that hasn't changed anything. The users can see the
PDF being created but a blank email doesn't open from their email client as
it used to. The client is on version 10.00.0991 and I thought this issue was
to be resolved in 10.0 SP 1 but obviously it hasn't been for us. The client
is also using Outlook. Is this still a bug with 10.0 or are we missing
I am on Adobe Acrobat Standard 8.0 with Microsoft ...Test your knowledge here.
Suppose there is a number is 100
Problem 1: The amount is decrease by 2%
Problem 2: The amount increase to 120
Conditions: 1. No hard-coding.
2. Use just ONE formula. This is to ensure that th
formula created is flexible. Can the formula increase the price by 6%
Can the formula decrease 100 to 80?
Thanks. Your help is highly appreciated
accountingfreak's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2551
View this thread: http://www.excelforum.com/showthread.php?threadid=...Lost contact list 04-22-10
I amusing Windows live mail...it had no problem picking up my contacts from
Now that I syncronized messages from my Hotmail e-mail account and my Telus
email account into Windows Live, my contact list is only the two contacts
from the hotmail account. All the rest are gone. They are still in the
Address Book, but I cant access them
How can I get it back into Windows Live Mail ??? Help please.
You signed into the Hotmail account when you started Windows Live Mail.
This is optional and not at all related to getting your mail.
When you sign in, WLM sync...Outlook 2003 03-17-10
1. Process will complete mailing address to sent item means anything ?
2. Repairmail up screen time that does not match the running because of what ?
3. The move affects the computer to send mail or receive ?
On 3/16/2010 8:19 PM, supatsiri wrote:
> Dear Sir,
> 1. Process will complete mailing address to sent item means anything ?
> 2. Repairmail up screen time that does not match the running because of what ?
> 3. The move affects the computer to send mail or receive ?
> Best Regards,
What is your native language? Please post ...test post
Testing my ability to Post.
...Reporting Services error when reinstalling DPM 07
I'm in the process of upgrading DPM 2007 to 2010. I did the O/S upgrade from
2003 to 2008 Server.
Now I'm trying to re-install DPM 2007 and I can't get past the prerequisite
The error is below:
Setup has detected that the installation of Reporting Services is not
correctly configured or no instance of Reporting Services is linked to of
1)To use the local dedicated MS$DPM2007$ instance with DPM, uninstall SQL
Server and run setup again.
2)To use the option of installing DPM with an existing instance of SQL
Server, make sure that the Reporting ...Percentage tax calculation 07-01-05
i need to set the tax calculation at fixed value of 20% but i doesn't see
this features in crm.
Thanks in advance,
On Fri, 1 Jul 2005 13:37:17 +0200, "Joe Fischietti"
>i need to set the tax calculation at fixed value of 20% but i doesn't see
>this features in crm.
We have an add in that will do this. It allows tax rates to be set by
percentage on quotes, orders and invoices. The tax rate is set for
each product with a configurable default and may be over...disappearing e-mail 04-21-10
This has happenend several times: Vista; When I open my e-mail, some email
just disappears, it's not in any folder, it's just gone. I''ve read other
threads that say make sure you are are set to show all messages and I am.
"Trish1856" <email@example.com> wrote in message
> This has happenend several times: Vista; When I open my e-mail, some
> just disappears, it's not in any folder, it's just gone. I''ve read other
> threads that say make...test #11
please use the test groups
"h" <firstname.lastname@example.org> wrote in message
...Mail Merge 03-12-10
I have a log that has multiple lines with the same individual that I am
trying to merge into one page per individual in word, I have to do a more
advanced mail merge.
Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.
Gord Dibben MS Excel MVP
On Fri, 12 Mar 2010 08:33:01 -0800, Brooke
>I have a...Dynamics GP 10 Reporting Question
I heard reporting in GP 10 is upgraded. Does anyone know if it will be
anything like Rockton Software Dynamics Report Manager where you can send any
report to like Sql reporting services or crystal?
I haven't heard anything at all that reporting in 10.0 will be changed.
While I guess it's possible, I would assume for now that there won't be any
big changes in general. I would expect more MS Office & SQL integration in
the next version for sure, but I can't see everything rewrit...Home based Job For Indian
Want the pleasure of life, don't worry, work 1-2hours/day and earn Rs.
10,000-15,000/month online from your home/cafe/office
For details write # email@example.com
Please write the subject of mail as: "Job Inquiry"
...test for exernal links
Is it possible to test if a workbook has external links to another workbookl
what i am trying to do is display a message when a user closes a workbook
saying the workbook has external links.
How would i code this??
I believe there is a security setting that does this check when the workbook
"hervinder" <firstname.lastname@example.org> wrote in message
> Is it possible to test if a workbook has external links to another
> what i am trying to do i...CRM dev to test to prod
I am just getting started on a CRM implementation. How successfull have you
been with three different environments and promotion of customization/data
from dev up to produciton?
Are there any tricks to promoting from one environment to another?
Thanks for your help!
We often use multiple environments. Change control and the export/import of
customizatins is the key. Depending on the data associated with some of tha
tables, you can spend some time migrating data as well, but that's no
different than any application.
MVP - Microsoft CRM
"Kenny C" <K...Problems installing WMP 11 On XP Professional Machine
WMP install fails with a '0x8007f00d' error. I have tried renaming
spupdsvc.exe, but that did not solve the problem. It is an XP Professional
Machine with SP2, and if I could fix the problem without updating to SP3 that
would be ideal. Following are the wmp11.log and updspapi.log files.
0.120: 2010/06/24 10:55:25.787 (local)
0.120: c:\3d75f72a135b08c2fda0e9328ba9\update\update.exe (version 220.127.116.11)
0.130: Hotfix started with following command line: /quiet /norestart /er
0.701: In Function TestVolatileFlag, line 11873, RegOpenKeyEx failed with
...Date and Time 05-14-10
I have cells in a worksheet that are formatted as date but still show as date
and time. How do I pull out the time.
04/07/2009 1:00:00 AM
I have tried the =left() and also =right () formulas with no luck.
Date and time are just numbers underneath the formatting.
04/07/2009 1:00:00 AM is 39910.04167
Format the cell to General to see that number.
Use Data>Text to Columns and delimit by decimal point.
In third step choose the right hand column and "Skip"
Re-format the cell.
Gord Dibben MS Excel MVP
On Fri, 14 May 2010 14:30:0...pick a number from 1 to 10
i want to create an asp.net web page that allows internet users to pick a
number from 1 to 10. how do i manage users picking the same number? (if 2
users somewhere happen to be selecting the same number and the same time). Is
this a concurrency issue?
On 19.12.2009 19:01, rodchar wrote:
> i want to create an asp.net web page that allows internet users to pick a
> number from 1 to 10.
You may use ten links or buttons. But what should happens after they
"picked" a number?
> how do i manage users picking the same nu...Customizations 03-10-06
using the "customization" in "Settings" showed me an "E-mail" entity,
althought there is no way to setup where to display it ("Areas that display
this entity") and I'd like to find out how to adapt this!!
Thanks for your helpfull reply,
Email enitity is a type od Activity, there is no way to modify display area
for activities in user interface.
You can try to modify sitemap.xml, but you will need some knowledge...
"Sture Van de moortel" wrote:
> using the "customization" in "Settings" ...Query help please 04-08-10
I have two combo boxes. Location and Super1
The location box lets you select a location where a staff member is working
at.For example U3 B-days.
The Super1 box lets you select their supervisor who works U3 B-days. As it
stands right now it will work. The problem is that it will show all
Supervisors through out the whole place.
I found a way where I can select from the Location box where it will pull up
just the supervisors for that location in the Super1 box. That works so far
Now, where the problem comes in is when the staff member is a supervisor. For