In Excel 2007, can you change the color of the highlighing used to select
text? It is very light and I can't really see what is highlighted

I'm trying to enter a date in a cell for an attendance roster I'm making.
I click a cell and enter "9/10."  But, Excel converts it to "###" in the
cell.  The Formula Bar reads "9/10/2007."
What is this ###?

I don't know if this can be done....
I currently have a spreadsheet with a couple dozen pictures inserted.  I was
wondering if there was a way to display only the picture name (ie
picture.jpg) instead of the actual picture...for purposes of printing drafts.

I currently have a workbook that has several macros.  One function I run
copies and pastes special-values certain formulas, maybe 100-200 times, and
also updates links to other workbooks.  THe computer I run this on is a 64
bit processor, but it takes a minute or 2 to run the ...

I have a pivot table created from a large spreadsheet that has a customers
entire inventory. I cannot get the available inventory to just show the total
for that location when I put it in the data area of the pivot table. It
always wants to do count or sum, but when it does these ...

enter following numbers in worksheet (in same sequence)
14189.05
-13605.77
-544.23

I have problem creating formula referencing a drop down list, can someone help?
Example:
In the drop down list, there are:
1-Below Average

Hi,
Is there a way for me to put the datasource,sheet and range information in a
cell, then reference the PivotTable to that cell to get the information?  
I have 3 PivotTables and would like to be able to access between current and

Excel has a quick and easy way to remove duplicate records, but I need to
mark them and then remove them one at a time from a very large spreadsheet.
Is there a quick and easy to just to flag duplicate records?
Thanks for the help.

I need help.  I'm not sure how to ask this question.  I'm trying to average
the number of entries during a specific time frame with a formula (or
anything else).  This is what my data looks like:
UserName

My folder is where it should be and my file names (12) are in the folder.  
However, 11 of my 12 worksheet files that are listed in the folder present
the following message:  "If you are trying to open the file from your list of
most recent used files on the File Menu, make sure ...

I have never used excel to any great extent but can find my way around simple
tasks.  However, I have one workbook which had 1 sheet of names in column A,
addresses in column B and other information going across to column y.  When I
tab across I can still see the info in column A ...

I need to match a part number and have it return the part number, the
quantity on hand, the value on hand, etc from a spreadsheet.
How do I match the part number and return multiple cells of information?

Does anyone have any suggestions on how to retrieve the filename of excel
into spreadsheet? for example
The name of working excel file is "Eric - RRRRR.xls", I would like to
retrieve the filename into cell A1, and to count the number of R within

ive tried using vlookup and lookup to no avail. i cant figure out how to do
it. can anyone suggest the correct function? for the purposes of assisting
me, assume
* my data is 326 rows long and 6 columns wide