Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?
=B5/A5?
Thank you

I have a large, multi-worksheet financial workbook and would like to import
data from a worksheet then break the references and keep the data values.
Someone sends in a workbook that was downloaded from the Internet (we
developed) then complete it and send it back by email. This ...

can anyone help me get command buttons working in excel2007 without
macros.thanks

What does one call this?  I can't find anything because I don't know
how to describe what I'm trying to do <g>.
In a financial spreadsheet I'm overhauling, I found something that can
be finetuned to make life less difficult.  Currently in a cell, cell

Want to know whether I can use formulas to calculate profit/loss on sales of stocks based on FIFO - First In First Out - or does it need VBA.
I have my stock 'Transactions' sheet set up as below:
Date     Stock    Action     Qty     Price     Brokerage     Trade Value
'Stock' would ...

I have a series of numbers - I want to project them into the future.
MS Excel Help screen "Project Values" says "You can fill in a series of
values that fit a simple linear trend or an exponential growth trend by using
the fill handle." It says to select 2 or more cells with ...

Can I get an autorecover file, if I closed Excel without saving changes?

I have two lists of account names (for example). 500 names in column A and
1000 names in column B. I would like to highlight or somehow alter the names
in column B that are in Column A without using the find and replace
function.. I do not want to do it one at a time but cannot ...

I stuck on a graphing problem.  Can anyone help.
I have a list of the times of day when I make phone calls. For example
13:31
14:02

What function returns the sum of all the numbers in a column without having
to specify how long the column is?  i.e. if I keep putting in new entries at
the bottom they must be added in to the total.
Rob Graham

i would like to know if someone know a macro which could save the value of a
cell in a txt file.
like in the cell A1 there would be written "something" and i would like a
macro to save that in a txt file.

morning all.
Over the past couple of years, whenever I work on one specific file, I
notice afterwards that there is an xlk file of the same name of the original
file.

I have a table something like this:
           A                        B                 C
1       From                To                  Result
2       01/07/2009    01/07/2010    0-1

If cell A1 contains a paragraph of texts and if I want to count just letter
"W"s (Upper or lower case), How can I achieve this?
Example: A1 contains "How now brown cow"  the formula should return "4".
Thank you.

I am in trouble!  Some time ago with massive help from readers of msnews. I
managed to build an invoice system for a local charity.  This is going well
and is well used without any bother to me BUT now they wish to change the
telephone number and name of the office and have ...