Possible to change the default cell format?
Hello - I am constantly changing the format of my cells (when they are
the number format) to include the comma separator and to use zero
Is there a way to change the settings so that by default the values
will not have decimal places (and by default they will have the comma
Thanks for any suggestions!
(FYI, I considered creating a simple macro to do this, but I believe
that it would limit me from being able to use the UNDO command as
often as I would like).
To address the "default" number format, you would have to use a template as your
default workbook...Any tools for moving CRM data to a Test Domain?
We have a test domain set up and we would like to move our CRM data over. I
have started the steps for data migration via the CDF tool - but hit a road
block with regards to IDs - it seems the CDF tables want a number ID and
will not accept CRMs GUID IDs. Before I go re-IDing everything - I need to
ask if there is a handy tool for moving your CRM data from one machine to
another (must go through CDF or similar, new AD)
are you using this Kristina?
this tool is the new way to move crms around
http://www.microsoft.com/downloads/details.aspx?FamilyID=bfced393-61db-49af-9a...Is this Multi-Search Macro Possible?
If it is not the right place for my question, please point me to the correct
I have a perplexing problem building a macro in excel that I hope someone
can help me solve as follows;
I have a stream of data values in column AB2:AB14516.
And what I would like to do, is to find lowest value in the last highest
group of 13 consecutive values, rather than the first group using Excel VBA.
Then put that value into cell W3 and the address of that group's range into
In addition, Identify the address of the five cells ahead of that group that
was foun...Is it possible to Track in CRM 4.0 to multiple records?
In CRM 3.0 we could Track in CRM and if it was already tracked, you would get
a warning, but still able to Track it to a second record.
The function has changed in CRM 4.0. I need to have one email that
addresses two separate Cases, tracked in both of the Cases. How is this now
...Server Performance Reports
I was just wondering about this feature. Is this a feature only available to
SBS or is it part of all Windows 2003 variants. If so, how is it setup?
...Possible to force output format of empty elements?
I have built a small integration app using VS .NET 2003 that extracts
orderinformation from a 'webshop'. Extracting the orderinformation works fine.
Appending the order elements in the XmlDocument was also done in a jiffy.
The final step is to save the document to disk and then ship it to another
system using ftp. The xml orderfile produced must fit a set specification of
the recieving system. That specification states that empty elements must be
formated in one line using a long format for empty elements.
It should look like this:
And not like...Workflow based on create Product entity -- possible?
Sorry if this is an elementary question -- I'm kind of fumbling my way
around on this, and I haven't found any documentation or resources on
any other sites that directly answer it.
The basic workflow I want to accomplish is for our accounting
department to be notified (via email) when a product specialist adds a
new Product to the system.
I'm trying to use Workflow Manager to create a new workflow based on
the create event for the Product entity type, but that type isn't in
that primary list in Manager. I see maybe 25 built-in types in there,
but not Product.
Th...Unit testing code containing private delegate declarations
I am using Visual Studio 2005. Now, I want to create unit tests for some of
my code. When this code contains private delegate declarations, MSV 2005
creates accessors for private methods using these the private delegates. But
somehow the delegate accessors are not created. This situation results in an
error saying close to 'the delegate accessor is not recognized' and tells me
that 'I probably should add references to assemblies, that contain the
The question: is it not possible to unittest code, which contains private
Have a nic...performance issue
I have an application which works fine on my machine, but it has performanace
issue on my user machine.
Our machines just sit side by side and connect to the same network.
Aything I need consider klike defragment HD?
Does Access have differnt process for different level ID like user ID who
has admin rights or not?
Tony Toews has a good Performance FAQ for Access:
If you work through the items in that list, I'm sure you will solve the
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -...Performance trouble when changing from XL2000 to XL2003
I have a rather large file (50 mb) that I have moved from a Win98/XL2000
computer to XP/XL2003 computer. When the file starts to calculate I get a
%-age figure reaching 20 % and then it simply stops. (I have a lot of
lookup-functions in the file.)
What can I do to get this fixed ?
I'm not sure I've ever seen a workbook that big.
But if I have calculation questions, I go to Charles Williams' site:
Maybe you'll find something that helps.
> I have a rather large file (50 mb) that I have moved from a Win98/XL2...Is It Possible To Dynamically Name Series?
I was wondering if Excel will allow a series name to be dynamic?
For example, ="30-Day Target, (" + sheetname!cell + ")"
where sheetname!.cell value is a date
to yield a Series Name = 30-Day Target, (mm.dd.yyyy)
I hope this question is clear. Thank you in advance for your help.
First, create that string in a cell. Use the Text function to format your
date in that string.
Then, in the usual dialog with the chart's Source data, click that cell as
the Series name.
http://www.wimgielis.be = Excel/VBA, soccer and music
...VLOOKUP with more than one possible response
I have a list of employees, Col A = Surname, Col B = Christian name, and Col
C = Employee number. On another sheet i have the same names but in a
different order (actually departments), to which i need to add the correct
employee number. VLOOKUP works but returns the first match only. When i
have two identical surnames, how do i then check the Christian names, to get
the correct employee number?
A B C
Jones Jane 123
Jones Jeff 124
Big dog is always right - The fugitive
If employee number is always a true number:
=SUMPRODUCT((A2:A10=&...Test Backup restore from Exchange 2000 to StandbyServer
I would like to perform a full restore (db and mailbox) from my
ExchangeProduction to ExchangeStandbyServer to make sure I become familiar
with new backup software setup recently. I also would like to have an idea
of time it takes to perform that backup and test data integrity often.
Besides my StandbyServer, currently I have just one server available (not
the same hardware used in the Exchange production) that I could use to setup
a lab for the testing. I have no $ for DLT or other servers like DC's I
would need to setup the lab.
Would be possible, viable and safe perform this restore t...test #8
...Is it really possible to just send an email?
I am one of those people who dreads coming back to Outlook. Here is the
reason why. All I want to do is send one email that resides with nine others
in my outbox. I have spent 4 hours trying to figure out how to send one
stupidly simple email. I have just completed writing 30 pages of code for a
website but I can't send one email with Outlook. Can somebody please put me
out of my misery and tell me how to do it or what is this program supposed to
be used for.
"cjcoombes" <firstname.lastname@example.org> wrote in message
news:2DD5E6E6-B45A-46AA-BF39-9A77B...Is it possible to change the RE: in the subject line when reply in Outlook
I wonder if it is possible to get Outlook 2003 to set another text in front
of the subject line when answering a mail.
I know that in e.g. the danish version it is SV: that preseeds the subject.
I have not been able to find anywhere in Outlook to change that.
I think that's built-in and not changeable.
"Svend" <email@example.com> wrote in message
> I wonder if it is possible to get Outlook 2003 to set another text in
> front of the subject line when answering a mail.
> I know...GPv10 SOP/POP link is it possible to add item to existing PO?
Hello, when in a sales order with a back ordered item, when I select
Purchase off the Actions menu and I=92m taken to the Preview window, I
see existing POs for this item on the PO tab but they are not in the
tree view. Only the item with New PO is listed in the tree view. Is
it possible to add this item to one of the existing POs for this
item? I tried to hit Organize and select a source and one of the
exiting POs on the PO tab as the destination but it don=92t do anything
and it sure doesn=92t add the item to the existing PO. Only creates new
POs =96 the same vendor.
Again, is this poss...Is this possible with xml web control ?
I am trying to use the xml control in a asp.net page. What i want to be able
to do is to store the data in xml format between two pages and finally send
this xml data to sql server database.
I am wondering is it possible to store data without actually creating a xml
file ? If so how this should be done..?
any samples or direction as to how this should be done is greatly
Thanks Victor..I appreciate your help.
"Victor Garcia Aprea [MVP]" <vga@NOobiesSPAM.com> wrote in message
> Hi sri,
>...Deployment and Performances
I am having a very strange performances problem with a webapplication after
deployment on the production server.
The following is the scenario:
1. My development environment: very quick responses
2. Testing environment (very poor hardware): acceptable response times
3. Production environment (very high resources: 4xCPU + 32 GB RAM): response
times are simply not acceptable at all. Note: this is the setup phase, so no
users load on the machine.
Trying to investigate I checked to be sure the code is identical in the
testing and production environment (precompiled loca...test #6
In article <firstname.lastname@example.orgR9absDaxw>,
(Test posts should go to to test news groups such as alt.test - not
Note: Please send all responses to the relevant news group. If you
must contact me through e-mail, let me know when you send email to
this address so that your email doesn't get eaten by my SPAM filter.
...Thread Safe DefineDosDevice Possible?
Is there a way to request DefineDosDevice to fail if the device (e.g. drive
letter) is already assigned. As it stands now it appears that the last
defined value is used. The problem is if two things are defining different
paths at the same time you can't tell what you're actually opening (going to
have to query the opened handle somehow to determine what it is because you
can't do any QueryDosDevice before/after opening a handle because it may
change by the time you call CreateFile to open the drive or by the time you
...Performing Division #2
Got it. Thanks a lot
JohnnyCat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1658
View this thread: http://www.excelforum.com/showthread.php?threadid=31446
See Johnnycat got it.
"JohnnyCat" <JohnnyCat.email@example.com> wrote in message
> Got it. Thanks a lot!