changing a range of fields
I have a range of fields that needs to be changed from a posivtive number to
a negetive number, how do I changed a range of fields at a time?
You can use another cell, so if you have 100 in A1 and in A2 enter
It will show -100. You can then copy this down as far as the data goes and
then copy it and Edit>Paste special...>Values over the existing data to
Microsoft MVP - Excel
"Mr. G." <Mr. G.@discussions.microsoft.com> wrote in message
news:A860AD8C-3626-4A0D-B84D...Changing User Passwords from OWA
I know that there is a way to enable remote users to change their passwords
using OWA for 2003 Exchange. I lost the article and can not seem to find it
on TechNet. Any help would be app.
"=?Utf-8?B?cGF1bA==?=" <firstname.lastname@example.org> wrote in
> I know that there is a way to enable remote users to change their
> passwords using OWA for 2003 Exchange. I lost the article and can not
> seem to find it on TechNet. Any help would be app.
Enable SSL. Here is a great walkthrough (link ma...Changing the default setting in MacWord 2008
Operating System: Mac OS X 10.5 (Leopard)
I just installed Mac Office Home and Student edition 2008. I want to change the default font and change the line spacing (it currently uses double spacing). I can make the changes on each new document as I start it, but Mac Word reverts to the pre-set defaults for each new document. Anyone ever able to change the defaults?
> I just installed Mac Office Home and Student edition 2008. I want to change the default font and change the line spacing (it currently uses double spacing). I can make the changes on each n...Changing "Reply To" address has no effect...
Outlook 2000 - if I change the Reply To address for an
email account it has no effect, the old Reply To address
remains for all mail sent through that account. Any ideas?
Where are you changing the address?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Mike <email@example.com> asked:
| Outlook 2000 - if I change the Reply To address for an
| email account it has no effect, the old Reply To address
| remains for all mail sent through that account. Any ideas?
...Outlook cannot perform this search
On using advanced search and search from the context menu I get the
error when the advanced search box opens.
"Outlook cannot perform your search. Outlook cannot display this
folders specified are not available."
The feature worked fine earlier.
I have tried the fix outlook /cleanfilters suggested in the KB and on this
newsgroup with not success. I have also started outlook in safe mode and
deleted all but the default search folders. I have also used the outlook
/resetfolders switch to start Outlook.
Even after all the above the error still persists. Is the...Change axis value
I have created graphs based on a database.. the figures entered into
the database are dates shown as 07/08/07 for example.
I have managed to create these graphs using queries but the y axis
shows up as '8'. how do i change this to show Aug instead?
thanks It worked.
one more thing Month 01 shows up as Dec! when it should be Jan?
...Modify code from paste values to change font color / multiple rang
I was wondering if you could help me out modify a code that currently paste
values to change the font color to automatic or black and to add multiple
ranges (new ranges are E8:E17, E24:E33,E40:E49 and E56:E81)
The current code is below and works Great! Thanks to everyone that
helped/will help me out!!
With Range("b48:b74").Offset(, Worksheets( _
"Summary by month MTD").Range("A4") - 1)
.Value = .Value
I'm not sure if those ranges are before the offset or after...
...CRM v3 + W2k3r2 - Install issue
I wanted to try CRM v3 on w2k3r2 server with sql2000sp4. The problem is
that when the verification goes on during install, i've got an MS SQL
Server Reporting Services error:
Erreur lors de l'acc�s � l'URL http://CRM�: Le serveur distant a
retourn� une erreur�: (404) Introuvable.
Erreur HTTP 404 - Fichier ou rpertoire introuvable.
I've checked with IE the by default web site, it looks ok.
Has anyone an idea??
The report server URL should look like http://servername/reportserver. It is
not the CRM server URL. If you browse to the repo...Outlook 2003 Windows Issue
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
Sorry to post this here, but I'm not sure of where to post issues with Microsoft Office for Windows issues. I also own & use Office 2008: mac, so I am an Office: mac user as well. And since we've seen other Windows issues here I hope it doesn't hurt to have one more. :-)
In addition to my Mac, I have a PC running Vista Home Premium SP1 & Office 2007, except for Outlook which is 2003 (I have Office 2007 Home & Student plus Visio Standard & Accounting Express).
I recently setup a GMail acco...How do I change existing text from lower case to upper case
How do I change existing text in lower case to upper case
same as your previous question, if the duplication was on purpose
it is a waste of everyone's time involved including your own.
"CT Cameron" <CT Cameron@discussions.microsoft.com> wrote ...
> How do I change existing text in lower case to upper case
"CT Cameron" <CT Cameron@discussions.microsoft.com> wrote in ...Is Edge Transport role necessary???
I have a question on setting up the Exchange Server 2007. In our old
Exchange Server 2003 system, we only have one Exchange server. Now I added
an Exchange Server 2007 in (I'm planning to remove the Exchange Server 2003
later). Users on the new Exchange Server 2007 could receive email without
problem and could send emails within our organization, but they could not
send emails to Internet. Roles of the Exchange Server 2007 are Hub
Transport, Client Access, Mailbox, and Unified Messaging. The planning
should be "simple Exchange organization with multiple servers"...change email address on emails
I have recently chnaged my email address and when i send emails from windows
my old email addres appears to the recipients, how can i change it to my new
address or do i have to craete a new account thank you.
Accounts | Mail | Properties | General | E-mail Address.
Imperial Beach, CA
"Katana" <Katana@discussions.microsoft.com> wrote in message
>I have recently chnaged my email address and when i send emails from
> my ...changes since uninstall of office 2003 beta outlook
Hello - I have uninstalled the beta office 2003 programs including
outlook and reinstalled the office xp programs. However, My outlook
still has a business contact manager folder available, but I can not
delete it. When I attempt to do so I get the following error message:
Unable to display the folder. Microsoft Outlook could not access the
specified folder location. An unexpected error has occurred. MAPI was
unable to load the information service IrisMS.DLL. Be sure the service
is correctly installed and configured.
Another change I have discovered is that when I go to Data File
Management,...Apostrophe changes in replies
Whenever a recipient replys to my HTML email, the apostrophe changes to
a carat and some other European looking letters, such as A and E and
some other unreadable characters.
Please help...... I'm using Office 2003 w/all updates Win XP home Serv
> Whenever a recipient replys to my HTML email, the apostrophe changes
> to a carat and some other European looking letters, such as A and E
> and some other unreadable characters.
> Please help...... I'm using Office 2003 w/all updates Win XP home Serv
> Pak 2
Did the font change? What language...Confirm data change on close
I want a data editing form to check for changes when the close button is
pressed by the user. The code I have entered reads "Run time error 13. Type
Mismatch" Any help would be greatly appreciated!
Private Sub Form_Close()
If Me.DataChange Then
Dim strMsg As String
Dim Cancel As Integer
strMsg = "Data has changed."
strMsg = strMsg & " Do you wish to save the changes?"
strMsg = strMsg & " Click Yes to Save or No to Discard changes."
If MsgBox(strMsg, vbQuestion + vbYesNo, "Save ...password issue with outlook 2k3
I am using Outlook 2K3. I get bad username or password when I try to
retrieve my emails from Comcast.net. If I test my Outlook configurations,
the test completes successfully. Yet when I try to send/receive, I get a bad
I have removed/reinstalled Outlook 2K3. I have the deleted the pssp entry
in the registry. Is there a file or registry setting that needs to be
deleted also? Where could the corruption be?
Any/All suggestions are welcomed. Your help in this matter will be greatly
appreciated. As always, thanks in advance..
What...MSMoney - min requirements
I'm using MSMoney V-2003 which I find to be very slow! The box
that it came in says that the program will run on a pentium II
computer with CPU speed of 166, but 300 is recommended.
I would like to know if anyone is using MSMoney on a computer
with only the minimum requirements and their comments on
My bet is that we will identify nobody who has entered more than a week or
two worth of data and wants to have some time left over to eat and sleep in
a day who is even close to the minimum or recommended.
How much machine are you running it on?
Have you read http://umpmfa...Unable to accept changes using Reviewer
Operating System: Mac OS X 10.5 (Leopard)
I have been working on a fairly large (40Mb) Word docx. The new version I started using the changes tracker (baloons by the side, no preview pane at bottom). However, I then moved office location and now need to break the document down and so I can email it. I did a save as Title 1/4 and then tried to delete 3/4 of the document. This worked OK but then I tried to accept this change as it is not a reviewable part of my document editing. I tried to do this by clicking on the tick at the top right hand side of the chang...Charts
Suppose my current chart has intervals of 0.00, 0.50,
1.00, 1.50, 2.00, 2.50 & so on across the y-axis based on
data that i have. Can i set the display or show values for
y-axis only as 0, 1, 2, 3, 4 & so on ? OR Is it possible
to set the numeric gap for the y-axis when drawing a chart?
Your help in this regard is appreciated. Thank You.
I seem to have got the solution. It is FormatAxis -->
Scale. This can be invoked by selecting the axis select --
> right click on the axis to be changed.
&...I need help changing the budget period!
I cannot find where to change the budget time period in
this program--I want my budget month to start at the 10th
and end at the 9th of the following month instead of the
traditional start at the 1st and end on the last day of
the month. Does anyone know how to do this!
...Changes in Outlook Web Access
I am running an NT Server with Exchange 5.5
When users log remotely to check their email in their Sent Items they see
who the email was sent from. Is there a way we can change this to who the
email was sent to?
Anguel Iordanov <firstname.lastname@example.org> typed:
> Hi Guys,
> I am running an NT Server with Exchange 5.5
> When users log remotely to check their email in their Sent Items they
> see who the email was sent from. Is there a way we can change this to
> who the email was sent to?
...Changing CToolBar size ?
Is there a way I can change the height of my CToolBar ?
It's the standard non-docking bar at the top.
I tried a few things and nothing works.
...SetValue to change Query ?
Is it possible to use the SetValue macro command to change the criteria of a
field in a query ? The Field is "Account Manager" and I would like to design
macros which changes the critera to the name of a different person each time.
Many Thanks in advance
No, the SetValue macro action is not applicable to this task.
If you could clarify the meaning of "each time", someone may be able to
suggest a suitable alternative solution.
Steve Schapel, Microsoft Access MVP
> Is it possible to use the SetValue macro command to ...Make the icon in the system tray for Outlook change when you have.
You have to physically open outlook to know if you have a new e-mail. Thats
annoying. The system tray icon should show you whats happening in an
unobtrusive fashion (i.e. no blinking) just change the icon to something new.
No you don't; you will get an envelope in the Notification Area when a new
If you don't see this icon;
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Kasmoie&...change default font when reading message
I am using Outlook 2003, use word for editor and reading of rich text and I
compose in HTML
When I read messages i want to change the default font to a larger size.
I have done tool>option>mailformat>startionary and fonts but
emails from outside my network come thorugh with changes and emails from
inside the network do not.
Any suggestions other than select all and then
tool>option>mailformat>startionary and fonts