Cannot clear @ formate entered in a cell by mistake.

Hi, i have a lookup i'm currently using; "=VLOOKUP(A3, ELMAX, 2,)" I want to expand this formula to include an IF(ISNA aspect as when the value being looked...

Hi, I have typical issue. I update a data sheet (let's say main data) every week and the data is as under Main data Name Week 1 Week2 ...

Hello All, I had created benign table, but of course, the powers at hand changed their mind on their goals and have started asking questions that are...

I am trying to modify a coutif formula. It has worked up to this point. Now when I try to add another +countif with another qualifier to it the result is...

i got a worker who does a lot of record in excel...she was recently updated to 2007 office professional...on some records when she opens it up from a ..xls...

When opening a spreadsheet in Excel 2003, I get a "Code execution has been interupted" message. I've been using this same spreadsheet for 3 years and I only...

Is there a way to change the font color as it is loaded into a form on a combobox? I have items that I am adding to a form and I want to keep the font color...

I just upgraded to 2007 and am disappointed with the faint highlighting color when dragging and selecting groups of cells. I just installed SP2 Office...

I have always been frustrated with this not being able to customize my spreadsheets. Does anyone know how to find the place to go to change the headings for...

Would someone be able to tell me how to enter a calculation to subtract one group from another in a pivot table, without having to modify the source data. ex...

How can I make a continuous list of the days of the week without including Sunday? I use Excel 2000. I need to make a "to-do" list for everyday, except...

Hi, I created pivot tables in Excel 2007 based on Access queries. The problem is that when I open the Access database, the database is read only. If I...

I have a Pivot Table Report in Excel that is connected to a query in Access. The query will either provide a zero (0) or another number based on a condition....

I opened an excel spreadshhet which didnt contain the minimize, maximize and exit button? now all my sheets are like that the only way to close a sheet is to...

I have a drop down list of recipes. How can I set up the drop down list so that when a recipe is selected, all the ingredents are listed in a separate sheet?

Can I add a list of products into a drop down menu on a custom toolbar?

Hi All, It would be very useful for me to be able to use SUMPRODUCT to get the maximum and minimum values depending on type similar to using it instead...

I want that my workbook numbers from 1 onwards till the last page of the last worksheet. I don't want each worksheet to start numbering from page no.1. Please...