General

how do I change column totals from number signs to amounts?
I have been using the worksheets for months but all of a sudden I have two columns of figures that have gone into ###number signs. How do I fix this? ... 3 Jul 2008 13:32

Using reference column # in IF Statement
A B C D E 1 Bob Sam Tom 2 =if(c3=0," ",row()) 10 0 4 3 0 5 4 4 4 5 8 0 5 5 4 0 0 I want to be able enter "Bob" in A10 and have the reference in the formula in B2 look to A10 to get the column needed for the calculation. If I change to A10 to "Sam" the formula would change to ... 3 Jul 2008 14:34

Costed Multi Level BOM
I have an file (in excel/access) which states are parent part number (col A), level (col B), children part number(col C), and qty (col E) for parts manufactured within my facility. I have a seperate table which summarizes all the labor $ associated with the different children and parent part numbers. I am having tr... 3 Jul 2008 12:31

Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi
Hi, I'm using Advanced filter, to search for a different criteria and now I'm stuck with this problem. One of my columns contains a list os secondary languages: Users Name Secondary Languages Joe french, german, italian Fred Japanese, french, arabic Using advanced filte... 3 Jul 2008 14:34

decimal places and leading zeros
I need to format a column of numbers (dollars and cents) from an outside company to ftp it to a financial website and it must be in the following format: Leading zeros to make the cell 10 characters long and can have no decimal point. I did a custom format which is fine until I get to a dollar amount that... 3 Jul 2008 14:34

Unable to update links
Problem... 2 spreadsheets in different folders. One "Postcodes.xls" provides a postcode/town lookup range for the spreadsheet "Data.xls". So, in DATA you enter the postcode & a lookup searches down th erange "PCDS" within POSTCODES to find a match. However, when POSTCODES is not open, the lookup fails & returns... 3 Jul 2008 12:31

animate text in Excel 2003
Kevin B wrote: Chip Pearson's web site has instructions on how to get blinking text in Excel. Here's the URL: http://www.cpearson.com/Excel/BlinkingText.aspx Please note Chip's warning in his first two sentences: Excel does not have any built in feature to make text blink, and many people, ... 3 Jul 2008 12:31

Averages
I would like to add a row of numbers but only certain cells in that row and then average the total can this be done so I do not have to change the formula all the time,I add a new number in a new cell every week. Eg: A B C D E F G H I J K Name 60 3 72... 4 Jul 2008 04:54

How do I disable pre-loaded shortcut?
I navigate fairly quickly through the worksheet, and I frequently copy and paste. If I go too fast, I inadvertantly overlap keys and trigger a shortcut - especially jumping to the last empty cell (which is often the end of the sheet). Can I disable this or at least reduce the sensitivity? Thanks! ... 3 Jul 2008 14:34

Using COUNTIF with AND
This should be pretty easy; it's a little embarrasing to ask. I'm trying to count all cells with a value within a specified range. It's not working. Here is the formula I'm using: =COUNTIF(A1:A17,(AND(A1:A17>3,A1:A17<6))) Where am I going wrong? ... 3 Jul 2008 16:38