"X" marks the spot
I am working on a call center checklist and I am trying to get c10 t
display "X" when b10 is clicked on, c11 to display "X" when b11 i
clicked on, and c12 to display "X" when clicked on. This process wil
continue with d10/e10, d11/e11, etc.
The sheet sample is included for clarification.
Thanks for any help in advance, and a good day to all. Vato
Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61512
Message posted from http://www.ExcelForum.com
try the following worksh...Delete Emails Older Than X Days
Does anyone know if it is possible to configure Exchange Server 2003 Standard
Edition to delete any emails in a mailbox (not just in the Deleted Items
folder, but also in any other folder) if it's older than X days. My company
would like to implement a policy where we delete all emails older than 90
days, and individuals are responsible for archiving their emails if they want
to keep them for longer than that.
On Fri, 24 Jun 2005 14:45:04 -0700, Equilar Tech
>Does anyone know if it is possible to configure Exchange Serv...How can I write in a text in a cell using numbers and the letters.
I'm trying to get some codes in for example 511E09 is one fo them but when I
try to enter another code it makes the code a formula and it changes to
5.11E+09 why is that? I tried changing it by formatting cells to text, but
that doesn't change it. Waht can I do?
Clear the data, change it to text, and then enter it.
(remove nothere from the email address if mailing direct)
"Sandy" <Sandy@discussions.microsoft.com> wrote in message
> I'm trying to get some codes in for example 511E09 i...copy/paste into excel changes numbers into date format
I need to copy a lot of raw data from html format into
Most of the data consists of a min/max figure (eg. 31/45)
Excel (2003) always converts this number to date format
no matter what I format the cells as. I have been
unsuccesful in converting back to the same format.
Any help or advice is appreciated.
try formating the cell s as 'Text' before pasting the values
> I need to copy a lot of raw data from html format into
> Most of the data consists of a min/max figure (eg. 31/45)
&...Excel crashez every time i open a worksheet with formulas
I would apreciate your help, thank you.
I have Windows Vista Businees x86, Microsoft Office Basic 2007.
The problem first appeared when i reinstalled everything a few days ago.
The steps i took are the folowing:
Format c: -> Reinstal Vista(internet cabe unpluged) -> install Office ->
start Office - > open worksheet(any worksheet) -> Office crashes
I also tried the folowing:
Format c: -> Reinstal Vista(internet cabe unpluged) -> install SP1 then SP2
-> install Office -> install updates(windows Update) -> all updates
installed-> start Office - > open wo...Word 2001 for OS X
Simple question that I just can't hunt down the answer to, and I hope
someone could just answer pretty easily. . . . Does Mac Word 2001 work
on the latest version of Mac OS X (10.3.7 I think)??? And I don't mean
in classic mode, I mean does it work like any other program without
having to use classic mode. I think so, but I need to know for sure.
In article <firstname.lastname@example.org>,
> Simple question that I just can't hunt down the answer to, and I hope
> someone could just answer pretty easily. . . . Doe...Office X to 2008
Can I upgrade directly from Office X to Office 2008 or do i have to install 2004 first?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 2/5/08 9:10 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> Can I upgrade directly from Office X to Office 2008 or do i have to install
> 2004 first?
The upgrade will ac...Maximum number of recipient policies
We are talking to a company that hosts Microsoft Exchange. They currently
host well over 1000 mail domains and bumped into a limit with the maximum
number of recipient policies that Exchange supports.
I couldn't find any document that talks about this limit. They get around
the limit by not using recipient policies, instead they have an event sink
that somehow solves the problem.
Does anyone know anything about this limit?
What event does their event sink hook into, and what does it do?
I really need some help thanks...
I am not aware of any thing that discusses...Permission for Active X
Every time I go to a certain web site I get a banner across the top of the
page saying something like
"This site has been blocked from downloading Active X control"
Every time I have to click the banner and give permission.
I know the site and would like to give it permanent permission.
Can I do that ?
On Tue, 11 May 2010 23:44:47 -0400, FDLeyda wrote:
> Every time I go to a certain web site I get a banner across the top of the
> page saying something like
> "This site has been blocked from downloading Active X control"
> Every time ...What is my x-value in a trendlinde based on dates?
I have made a chart showing prices every month. Now I have added a trendlinde
and can see the formula.
If I want to calculate the exact "trend-price" - what is then my x-value for
a given month?
You will find information on the LINEST formula, which will allow you to
create formula to resolve your problem.
Andy Pope, Microsoft MVP - Excel
"RSunday" <RSunday@discussions.microsoft.com> wrote in message
&...retrieve mailbox size and lastLogon time from LDAP or WMI
I have two Exchange cluster setup...
1. Exchange 2003 EVS installed on windows 2003 server
2. Exchange 2000 EVS installed on windows 2000 server
My requirement is to get Exchange server mailbox size and lastLogon
time information using either LDAP or WMI.
As I know for both win2k and 2k3, from LDAP I can connect to Active
Directory and get all mail user accounts, there lastLogoff time,
lastLonon time but not mailbox size info as this info will not be
stored at Active directory database.
I can use WMI for win2k3 Exchange server to get all this info but
there seems to be no WMI supp...Cannot Open my Microsoft Office MAC
Everytime i click on the icon, it bounces one time on the bottom and
then dissapears. Can someone please please help! Email
firstname.lastname@example.org with any answers.
On Sep 13, 1:25 pm, kate.lau...@gmail.com wrote:
> Everytime i click on the icon, it bounces one time on the bottom and
> then dissapears. Can someone please please help! Email
> paris...@aol.com with any answers.
I too have this problem. I uninstalled it and now the installer disk
won't even work. I really need it to work because I have school, so
help would be amazing.
On 9/13/07 1:25 PM, in article
1189715121.229325...Inserting Recurring Numbers Excel
How do I insert a number in a form that I created? This number should
increase by one (1) everytime I open the form? I am lost!
do you save this number somethere?
"Nettie" <Nettie@discussions.microsoft.com> schrieb im Newsbeitrag
> How do I insert a number in a form that I created? This number
> increase by one (1) everytime I open the form? I am lost!
...Active X buttons HELP!!!
I made a simple activex control and I tryed to use it in a modeless dialog
of another application (multi document app). Check boxes, lists and
everything seems to work just fine except the buttons. When I push a button,
seems to loop or something (high CPU). Anyone can help me?
Thanks in advance.
I'll try to help. I think I had a similar problem once and what I did was
go to Project->Add to Project -> Components and Controls -> Visual C++
Components and select "ActiveX Control containment component". That fixed my
problem. Hopefully it wi...How to alter data on HTML webpage into Excell cells as numbers?
A saved HTML webpage is opened with Excel 2003. The HTML webpage has columns
of numerical data which go into Excel cells. If we operate on the Excell
cells, the contents of the cells do not behave like numbers. This is so also
after formatting the cells as numbers. However on the same spreadsheet the
other blank cells are properly reformatted as numbers.
When a cell is formated as text and has numaric data in it, changing
the format to number or currency will not work. Even thought the format
in the Format cell pop up box appears to be in number or currency
There are ma...Pictures show red x when published to the web
When I create my .pub document everything looks great and still looks great
when I do a web preview of the document. However, when I create my
index.html file and post it to the internet through my web hosting company
(godaddy.com) no pictures show up. All of the pictures have Red X's and the
links to the different pages do not work either. Can someone please help me
with this problem?
I called godaddy.com and they said it was a problem with my scripting of the
pictures. Please help.
When you Publish to the Web in Pub 2003, you will produce not only the
index.htm file, but als...What is the table that saves next invoice number?
What is the table that saves next invoice number?
Look into "RM40401"
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
Great Package For Business Solutions
"Malek" <Malek@discussions.microsoft.com> wrote in message
> What is the table that saves next invoice number?
That depends what invoice number you are talking about.
If referring to SOP, the invoice number will be stored according to
...Numbers are changed in Excel?
I created a spread sheet of some stuff. I entered some serial and
account numbers. For some reason that everyone but me probably knows
the numbers are changed by Excel by inserting a ., a + sign, etc. hat
are not as I typed.
What's going on here?
I would say it's some formatting (either default or pre-existing) in those cells.
Try giving all those cells the "Text" format. Then Excel won't add decimal places or signs. I -think- Excel won't let you do math with those values (unless you convert them first), but you probably don't need to add or subtra...how to add an additional title to the x-axis
I need to have 2 different bits of information on the x-axis - both semester
and type of assistantship. For example:
In 2002 - 2003 there were Teaching assistantships, Research assistantships,
Administration assistantships and then the Total # of assistantships. All
that shows up is the year with the tick marks for the different
assistantships. I want to labe the tick marks
Can someone suggest how I might do this? I have tried the help on Excel
with no luck.
There are more ways to do it, depending on what messagey you want to portray.
You can make a stacked co...PowerPoint 2004 replaces charcters with black squares when printed- PPT v.X does not
After installing Office 2004, I tried to print a PowerPoint technical
document (138 pages) that I had originally generated in PowerPoint v.X.
Many of the 2004 print pages contained black squares in place of the
actual character. I used Helvetica for the text, had embedded graphics
generated by Canvas X, and MathType 5.1 for equation generation. Some
of the imported graphics which had text also showed the "black death"
phemnomenum. Note when I printed the document under PPT v.X everything
came out perfectly.
I am running a dual 2 GHz G5 Macintosh with 3.5 GB RAM under OS 10.4.3
(Tig...Converting to 2000 from 1.x
I'm working on a rather old application that uses a Access
1.x database. Unfortunately, Access 2000 does not support
conversion from 1.x. Is there any way (other than digging
up a really old copy of Access) that I can convert this
...Excel: Repeating Row 1 Content at top of all printed pages
I see in the Setup - Sheet's Tab you can select Row and column headings to be
printed, but that prints the litteral headings such as A, B, C and 1, 2, 3
I need for have the content that I have named my columns reprinted on the
top of each page so that users of my printed spreadsheet don't have to flip
back to page 1 see what the titile of a certain column is to understand the
data in a certain cell in page 3, etc. of the worksheet in printed format.
I'm familiar with the freeze pane issue so you can see the title cells when
scrolling the worksheet - that's not my issue -...Setting time on Outlook Express
Hi & thanks for trying to help.
My PC clock is set right but my email messages are going
out with the wrong time on them. Does anyone know how to
adjust the time in side the program Outlook Express so
when I send an email it's going out the right time?
...Shared public folder calendar in Exchange: how best to have subscribers request vacation time?
I've set up a SBS 2008 Server for our small business (medical practice with
four partner physicians). I'm creating a common calendar for partners' work
schedules, using categories such as "on call," "vacation," "business
I'd like the subscribers to the calendar to be able to submit requests for
time off, on-call changes, etc., to our office manager so that she needs to
massage the requests as little as possible before posting them to the shared
Can anyone suggest a streamlined workflow for this?
Most subscrib...I want to use Page x of y without y including cover and TOC
I want to number the body of a report using Page x of y, but I can't figure
out how to exclude front material such as cover and toc from the total number
of pages y.
On Mon, 7 Dec 2009 16:35:01 -0800, Misdeerose
>I want to number the body of a report using Page x of y, but I can't figure
>out how to exclude front material such as cover and toc from the total number
>of pages y.
The first step is to separate the front matter from the rest of the
document with a section break, as described in these articles: