I am having a problem with e-mail address in excel spreadhseet.
Some of them go in, in black the same as the rest of the spreadsheet, but
others show up in BLUE and then they are clickable. I would just like them
all in black.

A    B    C    D
as    tr    cf   x
er    wr          
sg    rt   yu   x    

I recently upgraded from 2003 to 2007 and the issue just started happening
after this.  The issue is, when i open an excel document by double clicking
it in the explorer, it opens excel, but no workbook.
By clicking again on the document it opens ( or just minimize/maximize the

I'm trying to copy/paste some text from a Word document into a single Excel
cell in worksheet that was created by someone else.
The text has about 250 words/about 600 characters or so.  There are about 5
major points, each point has about 4 bullet points underneath it.  There's

my data is as follows
row 1  1    2    3    4    5
row2    2    3    7    10    8
the explanation is as follows: Row 1 is the degree of rating for a movie

All,
I have a dynamic range list but there are many duplicates within 900+ entries. Is there anyway to prevent duplicates from showing in a dropdown?
David

I have a savings calculator that i am working on.  we have three products
that i would like the user to be able to select from.  basis their selection
from the drop down list, i would like a corresponding value to go into a
certain cell.  

Is there any way to remove the "All" option that comes in the page
fields in a pivot table??

I'm using Excel 2003.
I have a spreadsheet containing a database query (inserted using
Data->Import External Data->New Database Query) with 5 columns. The 6th
column is a notes column, in which the user can type little comments to

Is it possible to make the excel IF function give me the result of a
mathematical calculation as an output?

To be honest: for now I lack the spirit to solve my problem by myself.
And it must have been done before so I just ask for help. I'm a lazy
bastard ;-(.
In Excel 2003, a list with items in column B.

I've recorded a simple macro for Excel, where I work with a row. But I want
to work with a row the active cell is on, but Macro Recorder has writen me
an absolute referencing. Should anyone help me, how to rewrite the code?
Sub Zašedění_řádku()

I am trying to count the total of leave taken without the holidays
and
the weekends
i have used the NETWORKDAYS but i dont know what is the formula in

When I enter a whole number (i.e. - 1, 2) into a cell, the result is a
percentage (i.e. - .01, .02).  I have reset the format to number, with no
success.

I am attempting to use Data Validation to create a lookup from a different
sheet. What do I need to input into the Source Field so that sheet 1 will
pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6.