Hi Candido! First, I don't think that you can control Excel's intellisence formatting except by pre-formatting the cell to a format other than...

I have a Zip Code Table with only the first 5 digits and do not have the last 4 digit. How can I make them in 9 digit zip code with the last 4 digit as...

Hi -- I have a basic timesheet in Excel 2003 - that has In and out with in/out for meals - I want to know if there is away that I can round the times only...

I am interested in linking a formula to the colour of the cell. Ie. positive number would produce a green cell & negative cell would high light the cell in...

I have colum A and B. I use SUMPRODUCT to calculate the sum of values in column B with a criteria. What I would like to do is copy the cells from column A...

I have a user who is using Excel as a database – ugh. One of their columns (fields) has contact data points. As an example, a cell might state –...

Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side...

I have a column listing numbers in worksheet B. I'm looking for a formula to place in worksheet A that will list the bottom number listed in that worksheet...

I input my formula, but would like to fill in the data later. How do I save the Formula without there being data. I am trying to create time sheet that will...

I’m using this formula; =IF(OR(‘Source Sheet’!C10={“�,�C�, “B�}),’Source Sheet’!B10). This allows what I enter into the source sheet to...

Hello, I made conditional formulas but with the numbers that result I am unable to calculate their average. I get the #DIV/0! error. They are formatted as...

I am working with a model in which I am converting to a current scenerio. When I go into a specific cell to change the link it gives me a error that reads "No...

Hi A1 September 1, 2010 Years of Services Age A2 B2 C2 ...

OK, need help with the following: Mod(10e+11;97) returns #NUM!, anything higher it blows. But if I use Mod(n;d)=n-d*INT(n/d) I can go until Mod(10e+15;97),...

I’m using the formula below, in a worksheet to count cells containing the letter S. My problem is in the total cell, it displays a 0 until I enter an S in...

Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I...

I am trying to figure out, if possible, to make certain blank cells in a row/column to be filled-in (blacked out) if a certain cell contains a particular...

Hi Excel Forum, Hope you can help me..... Calculation on Filtered Visible Cells. Working with Filtered Visible Cells - need calculations to recognise "only"...

Hi, Im trying to check that one row of data satifies a criteria, then if it does it counts an entry in another column adjescent to it. Example: - Column A...

I'm using Excel 2003 so I hope I'm not limited here. We are performing a space usage survey and I need to compile the data results. Each location has 70...