Is there a way to format negative numbers in red WITHOUT fixing the decimal precision. i.e. if a cell is formatted as "general" then the number 1 displays as...

I have extracted the month from the worksheet name using the CELL function to give me the month name as text. Is there a way I can convert this to a...

When prompted to select from the drop down list, it starts at the very bottom. You then have to scroll up to get to the top of the list. How do I change...

Hey all, The following is in one cell and I need a way to extract just the numbers so that I can put text to column the numbers. For example, my end goal is...

In a spreadsheet I'm using the Validation Data tool to create a drop down menu for cells but all the background colour is white no matter how I shade the...

For those of us that sometimes don't want to add $ signs after our formulas are written, how about a feature in Paste Special that let's you copy the formula...

Hi everyone, I found Excel 2003 is more friendly than Excel newest version! Location of many funtions of newest version are no longer easy to find. For...

I'm using Excel 2002. There is a small yellow box, in the middle of a spreadsheet, that I can't get rid of If I delete the row it's in, a row gets deleted...

Need to be able to have cell B4 decrease by 1 every 30 days until it reaches 0 I would also like to be able to take values in A17 move up one if A16 is empty.

I have identical MS Excel worksheets stored in different drives. I want to update them all when i update my master copy? Any way out?

I have a pivot table that toggles markets and products with metrics as row labels and weeks as column labels. I would like the dates to be sorted from...

how do I compare the actual results of two formulas? Example: P1 has a formula =edate(z1,10) and AF3 has a formula =edate(ac3,8). Want to compare the results...

I'm trying to calculate a net total by taking a number times 40% and then deduct that percentage from the number to get the net total. How do I create this...

How can I number rows but omit any hidden rows from the numbering sequence?

I double click the format painter & use it once & then it shuts off. How can I get it to stay on til I turn it off? -- - L Fox PMP

We are noticing that images and objects (including charts, logos, wordart, equations, etc.) are not staying in the same relative space on the page when...

I am trying to create a sheet that tracks the items entered into a certain cell, or group of cells. What is the simplest code to accomplish this? Ex: I...

Should be really simple, but I'm missing something basic. In the Cell.Replace (I want to replace the formula for the entire workbook) & If this can be...

Two Part Question: I am looking for code that will locate if a sheet by a specific name is in the workbook, and then delete it if it is. What is the easiest...

Hi There, I am getting a value error when using the following formula: =SUMPRODUCT(--('Detail Hours'!$F$1:$F$1000=D$3),--('Detail...