How do I get excel to accept (c) as text and not change to copyri.
How do I enter the text (c) in Excel without having it changed into the
Tools | Autocorrect | Select (c) | Delete | OK
"daffyd" <email@example.com> wrote in message
> How do I enter the text (c) in Excel without having it changed into the
> copyright symbol?
Go into the Tools Menu. Look for AutoCorrect. In the bottom half of the
AutoCorrect Tab, look at the list for Replace text as you type. Delete the
entry for (c).
"da...Publisher 2000 changes default font
Having loaded Publisher 2000 onto a Win98 m/c I have
discovered fonts used by Groupwise have changed. This
implies that P2000 has changed the default font somewhere -
any ideas please?
How do I change the fonts in GroupWise
Mary Sauer MS MVP
"PS" <firstname.lastname@example.org> wrote in message
> Having loaded Publisher 2000 onto a Win98 m/c I have
> discover...Change outbound server in header to fix 550 Can't verify your host name error
The headers on the outbound emails show the internal DNS name of our
exchange server; obviously this won't resolve properly at the
How/where in Exchange 5.5 can I force the IMC to use a real fqdn on
You can do this in TCP/IP properties\Advanced\DNS tab of machine. And
yes, this is not just for Exchange, so you may consider forwarding all
outgoing mail to some relay server (your firewall or ISP's server).
Professor Frink wrote:
> The headers on the outbound emails show the internal DNS name of our
> exchange server; obviously this...why do changes only save locally on networked excel file?
why do changes only save locally on networked excel file?
...How can I stop charts from refreshing when changing source data?
My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...Font problem with Office 2004 for mac
I have Tiger, whenever I try to Launch any Office program, as the the
menu loads to 'optimizing font menu performance' It pops up with 'The
font " " has been corrupted and should be removed'. It does this
with MANY fonts, many of which I don't even have in my font folder. It
does this every time during the program start, and most times even if I
go through clicking ok 40-60 times it will sometimes freeze up anyway.
Anyway to fix, get around this problem? Please email me at
this problem affects quite a few users, and there'...Count on cell for each time it is changed
I would like to count the number of times a cell has been amended/ changed
e.g cell b2 has the word red it it, in cell c2 i would like a counter for
everytime the cell in b2 has changed, at the end of the day you get final
number. Is this at all possible?
You can do it by putting the following VBA macro in your sheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Cells(2, 3) = Cells(2, 3) + 1
> I would like to count the number of times a cell has bee...Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the
Analysis toolpack, I figured things out quite recently that I can
install my Mac office 2004 and use the excel package that contains the
Analysis tool pack. How? ...... let me show you:
1. Insert your CD for Mac office 2004
2. When it open on your desk top, two options will be given to you to
download the software
(a) Office set-up assistant, and (b) Microsoft office 2004.
3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and
will start to run/download.
4. When done, this will appear as ...MS Excel Paste Special>Paste All
Using MS Excel 2003
Paste Special> Paste All, doesnt quite paste the 'Column Widths'. Am I
always required to do the two step dance, Paste Special> Column Widths and
>>Am I always required to do the two step dance
"Excel User" <Excel User@discussions.microsoft.com> wrote in message
| Using MS Excel 2003
| Paste Special> Paste All, doesnt quite paste the 'Column Widths'. Am I
| always required to do the two step dance, Paste Special> ...hide/change color of selected row headings
Is it possible to hide the row heading numbers for
selected rows (i.e. rows 51 and greater) for just the
selected sheet? I'd like to have a color with no row
heading number appear that matches the fill color I select
for the adjacent cells.
Secondly, any ideas as to how I can prevent the user from
scolling further down than a certain point (i.e. row 51).
Thanks in advance.
Row headings are either on or off, you can't hide some. However, you
can achieve a similar effect by hiding *all* headings
(Tools/Options/General) and putting the numbers 1:51 in A1:A51.
to limit scro...Office 2007 11-23-09
Of all the choices out there (community discussion, dashboard, live, etc.)
how can I contact someone with input on Microsoft's software. For example,
I want to know why any one would not display the most common commands on the
HOME tab in Office 2007. Print, Save, Open, Close, Spell Check, Undo, etc.
etc. etc. Yes, I know you can customize your own Toolbar, but not a
beginner. How can I emphasize how important this is, I don't suppose you can
customize the Tabs.
I would like to ask someone why they can't get input from those of us who
teach their products. ...error message in Outlook after running windows and office updates
I am hoping someone can help me with this. When ever a
few staff tries to send a new e-mail, a message "Do you
want to save changes" come up and on the back of this
message I see the spell checker box come up. The problem
is that if you click on "no" on the error message, it
comes up with another message something like "running out
of memory". I just ran all the windows and office updates
on all the machines in the company and so far two
employees are having this problem. Is this something to
do with the updates? Any suggestions?
did you try ...changing a name in mulit parts of a document
I am setting up a word document.
This will be used as a template
In this document I wish to insert the same "name" throughtout this document.
Is it possible to change the name in one spot and all of the others change
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>...MS Outllook 2003 with Business Contact Manager Backup/Restores
Need some help with what the procedure is to backup
Business Contact Manager data from a single user license
system and restore it on another backup system I have.
This needs to include the opportunities and other data
linkages made on the system being backed up. Tried doing
an export / import but based on some info I saw on the MS
Office Web site this won't work!
Would appreciate any help!
There is a backup/restore function for the BCM database on the file menu.
"WHY" <Hnyda@mindspring.com> wrote in message
n...change exchange name suffix
We need to change our exchange server 'name' suffix.
The situation is that we have a local DNS domain 'bs.si' where all our
company computers and server are (Win2k srv AD)
We have also external domain 'bs-group.si' that is also for delivering mail
(mx record). The Exchange server name is 'posta'
Now when someone connects to Exchange server from outside via port 25 it
responds like '220 posta.bs.si ...', but I want that the response will be
like '220 posta.bs-group.si'. So that mail that is coming from our server
will be seen like that i...Access To Word Mailmerge
I have setup a Mailmerge that is run from Access. The process works like
this: 1) The proper record is selected in an Access form which automatically
starts the process. 2) Word is called up automatically, it shows both the
template and the doument with the proper data in it. 3) Access is closed
automatically. 4) The user then needs to close the mailmerge template. 5)
The document with the proper mailmerge information inserted from Access is up
on the screen. At this point a shortcut is triggered by the user that adds a
document of the users choice to the end of the curre...Return Money 2005 DIRECTLY to MS :)
Just read the conditions of the 30-day Money-Back Guarantee and MS will
refund "reasonable" S&H costs up to $7! If you're unhappy w/ Money 2005, I
can't think of a better way to get your opinion across than to send it back
directly to MS (along with the "explanation for return" that they request)
AND stick them with the shipping bill. :) If you return it to the store,
the best MS will ever learn is that it was defective. Sending it back to
Redmond lets them know they just paid $5 extra for a product they rushed
out. Your voice will instantly take on as much...Changing password #2
If I change a domain user's password, will that user's
Exchange Server 2003 mailbox's pssword be changed too?
I mean, does Active Directory share the same password
with Exchange Server 2003?
Exchange never had passwords separate from domain, not even in Exchange
4-5.5 era. So you would change just one password, which belongs to AD
> If I change a domain user's password, will that user's
> Exchange Server 2003 mailbox's pssword be changed too?
> I mean, does Active Directory share the same password
> w...Date changing 2028....2029......1930???????
I have a slight problem, in my form i have a date section which is automated
as 00/00/00. I use these for part of a report as a from this date to this
date, if you put 010125 it will automatically change it to 01/01/2025. The
thing I have found is that it is fine until you get to 010130 and then it
saves it as 01/01/1930 :-/ any ideas?
Message posted via AccessMonster.com
Assuming you're using XP, go to Regional Settings in the Control Panel, and
click on the Customize button. Look on the...Dynamic chart: Changing Ranges
I have a set of data, going across by months, and going down into different
categories that I have to graph using stacked column charts. Since the data
is going to be in the same columns, just going down a category...I'd like to
know if there is a way for me to add some kind of drop-down to the chart so
that users can just drop-down to CATEGORY 1, and see the chart for CATEGORY
1, without me having to build 10 different charts that i'll have to update
everytime i add new data.
I would appreciate any advice or feedback.
Check out Jon Peltier's website. It looks ...MS Dynamics GP Sure Step documentaion
One of my client wants all the Dynamics GP implementaion and technical
documents should be in Sure Step documents methodology and I have the empty
templates also for these but bit confuse how to start. So can anyone inform
me where to find the sample sure step documentaion?
Your immediate reply will be greatly appreciated.
thanks in advance.
As far as I know, there is no sample documentation as such available for
surestep. However, You can find E-Learning and Training Materials on SureStep
in partnersource in order to learn the same.
Tha...Unable to connect Office 2003 to SBS Exchange 2000
I have two new XPSP2 workstations with Office 2003 but when after
configuring them for the Exchange server I get one of three errors:
a) on a profile migrated from an existing workstation (whose Office 2000
Cannot start Microsoft Office Outlook. Unable to open the Outlook
window. The set of folders could not be opened.
b) on a new profile using Cached Exchange Mode
Unable to open your default e-mail folders. You must connect to your
Microsoft Exchange Server computer with the current profile before you
can synchronize your folders with your offline folder file.
c) on a new...Change Opportunity Date to Quarter info
could you help me to convert MS CRM 4
Opportunity Estimate Close Date to Quarter info (and set quarter info to new
I'll do it on field onchange function.
2010.01.03 change to 2010Q1
2010.04.23 change to 2010Q2
So I need code for onchange funktion :)
On 17 Gru, 15:40, "B.I." <aid...@jdjdjd.lt> wrote:
> could you help me to convert MS CRM 4
> Opportunity Estimate Close Date to Quarter info (and set quarter info to new
> I'll do it on field onchange function.
> sample :
> 2010.01.03 change...Any way to change the transaction date?
I had a wierd issue recently when the server was restarted it went back to
I replaced board battery to fix the pblm but for reporting porposes is there
any way to move the sales data for what the system thinks is 1/1/2003 to
you can do so by using following query: take the backup before performing the
update [Transaction] set Time='2007-1-28' where year(time)=2003 and
month(time)=1 and day(time)=1
update Journal set Time='2007-1-28' where year(time)=2003 and month(time)=1
update TransactionHold set TransactionTime='...How do I change the default number format ?
The current number format is general. I would like to change it to accounting
with no $ and 2 decimals. I can't seem to find how.
I'd appreciate any help that anyone can give me.
Hi. You would want to change the definition of the "Normal" style.
From the menu: Format | Style...
And modify the "Normal" style
Win XP & Office 2003
"LarryH" <LarryH@discussions.microsoft.com> wrote in message
> The current number format is general. I would like to...