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...PUBLIC CONTACTS #4
I created a publix Contact list for all my users and gave them rights to
create but not delet.Also I gave myself fun right .
When we creat a new contact and try to save it I get an error:
"the item could not be saved to this folder. The folder has been deleted or
moved, or you do not have permission.
Do you want to save a copy of it in the default folder for the item?"
Can anyone help me with this proble ?
> I created a publix Contact list for all my users and gave them rights to
> create but not delet.Also I gave myself fun right .
> When we...Saving User Settings in Outlook...
Does anyone know how to save the user settings for MS outlook 2003?
Thanks to all who reply,
The reason I would like to be able to save the user settings is so I'll be
able to restore these settings should I need to in case I had to do a clean
install of WinXP and office 2003 either on the same computer of on another
newly bought computer.
Thanks to all who reply,
"Ismael" <I_Tena@hotmail.com> wrote in message
> Hello everyone,
> Does anyone know how to save the user setting...Calling Set/GetDefaultPrinter
I am using the Windows SDK calls GetDefaultPrinter anmd
SetDefaultPrinter. On my main development machine running
WIndows Server 2000, I compiled without a problem. WHen I
moved the project and tried to compile in my XP
environment, I get a compilation error that it is not
found. It also does not show up in my online help on the
XP machine. The function is defined as being part of the
Windows GDI API. I don't uunderstand why this would not
be showing up under XP.
Any ideas what I have to install or setup to be able to
use these functions?
>Any ideas what ...Outlook 2003 forgets contacts after 1 day
Outlook 2003 is remembering contacts for a day and then automatically
deleting them. I have spent the last hour searching and can't find the right
setting to stop this from happening. Has anyone got any advice?
Outlook does not automatically save Contacts ever. To what feature are you
"slycbod" <firstname.lastname@example.org> wrote in message
> Outlook 2003 is remembering contacts for a day and then automatically
> deleting them. I have spent th...Passing data from one form to another
Hello I have a form called frmMaindB and it has 5 text boxes on it
(txtEmployeeTime, txtDTRegular, txtDTReason1, txtDTReason2, txtDTMaintenance)
when I double click on the text box it opens up a pop up form named
frm_DecimalConversion. On this form I have two text boxes one box I enter
data into and the other calculates or converts the data to a decimal. The box
that converts the data is called txtDecimal. Then I have a close button which
I want to use to close the pop up form and insert the data into the text box
I double clicked in to get the pop up or (frm_DecimalConversion). I have r...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" <email@example.com> 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...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...How do I set the number format to Base 12?
I would like to change the number format on my spreadsheet from Base 10 to
Base 12, eg. 12 bottles makes up 1 case. Therefore, if I were adding up three
different cells 9 bottles + 11 bottles + 6 bottles, my result should be 2
cases 2 bottles if possible 2.2 in a case column.
See http://www.cpearson.com/excel/fractional.htm for details.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Andrew Moore" <AndrewMoore@discussions.microsoft.com> wrote in
>...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...email set up in publisher
I set up a newsletter and tried to email it, a setup wizard came up and I
cancelled it. now I dont have the send button for emails. how do I get the
wizard or send button back? Cassandra
> I set up a newsletter and tried to email it, a setup wizard came up and I
> cancelled it. now I dont have the send button for emails. how do I get the
> wizard or send button back? Cassandra
Start either Outlook Express or Windows Mail (whichever you have); this
should prompt you.
You have to have Outlook Express, Outlook, or Windows Mail set as your
default mail client to ...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?
...form and query problem. please help.
All tables are linked with weak entities. However, when i enter data on the
form I can't get it to let me enter more than one partipicant without access
generating a new invoice id. however i need one invoice to many participants.
It wont work and i have no idea what to do at this point. in addition the
workshop will not let me add workshop to invoice. this is a small mdb and i'd
like to email it to anyone who can assist me with the relationships as I
think this is the problem but I don't know what to do. please help me.
invoiceNO - autonumber
wo...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...OWA authentication settings
My single Exchange 2003 SP1 installation requires OWA logins to use the
domain\username method. At one point it only required the username. Not sure
when/why it changed. I have checked the HTTP Protocol settings in ESM and in
Exchange properties under the Exch VS, I have Basic... checked with the
netbios domain name listed. I also have Integrated..... checked. Anon.... is
not checked. From what I've read this is all I need. I shouldn't have to
check the IIS settings on the Exchange server. What am I missing? Thanks.
This probably changed after you installed an Exchange ser...Setting Global Options
Is there a way to set global options within VBA. I'm particularly interested
in setting the security level to low (to eliminate that annoying start up
message), setting the status bar to false and "Behavior Entering Field" set
to start of field. Is there some place that lists the options that can be
Thanks for the help!
On Thu, 4 Mar 2010 19:30:04 -0800, PeterM
For the latter two check the SetOption keyword in the Help file.
The first one requires a registry setting. You can google or bing for
...Setting up my Outlook at home
How do I set up my Outlook 2003 to work from home, but leave the messages on
the server (as I do at the office)?
I right-click Outlook and choose Email accounts.
I choose Microsoft Exchange Server.
I put in our server and my user name.
I also uncheck "Use Cached Exchange Mode", which is what I assumed was what
would move the data to my machine (which I don't want).
When I say click next, I get the Message:
"Mail from this Microsoft Exchange Server account will be delivered to the
existing Personal Folder on your local computer. If you wish to keep your
mail on your server...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...Recovering Contacts from BackUp Exec
I need to recover a contacts file from Backup Exec into Exchange but, the
contacts file is from an older version of Exchange (2000 small business) and
the backup was taken using an older version of Backup Exec (Version8.5), and
I've since upgraded our Exchange to Enterprise 2003. While Backup Exec 8.5
allows me to redirect the files, I would like to know if any has anyone had
any experience of a similar scenario? I suspect this will work, but don't
wish to take any chances.
Any help would be appreciated.
"contacts file "? Do you mean the contacts...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...Showing the perimeter of a set of (X,Y) data!
Good day all,
I need to plot the perimeter of a set of data.
I have a set of (X,Y) data with error bar and it is a nice mess so I
just actually need to see (show) the area were the data can be found.
Then hopefully overlay an other set of (X',Y') data and show that they
both cover the same surface of existence.
i.e this is a set of metrology measurement in X and Y of a part build
from different mould. Obviously you get a nice cloud of X and Y but
does the new material offer the same 'cloud' ?
I think the easiest way to do this is plot the data on a XY Scatter cha...