I have a range of cells with values I need to increase by a percentage.
Is there a simple way to do that?
Thanks,

I am trying to combine data from various cells into one cell.....using
a formula such as =c9&d9&e9 however if one of the cells were blank I
get a 0 in the end combination.  What can I do to eliminate the zero?
Or pehaps there is a better way to do this.  I have text and numbers in

How can I find out what certain formulas/functions on financial templates are
doing.
In other words I need an explanation of some of the gray cells in the
different templates.  Some are straight forward but others I cant figure out

I have a question that's been bugging me for a while.  I love using the
grouping feature to make expand/contract rows in a spreadsheet and find
it extremely handy, however, every time I select rows to group, no
matter which "direction" I select them from (top scrolling down or vice

A user opens an Excel file (with global macro security setting on
"Medium").  She is not prompted to "Enable Macros".  Instead, it opens and
macros are disabled.  Any ideas why?  Is there a way for her to enable
macros with the file open?

Hi i'm new here, so don't know if this questioin has been answered.
I have a list of about 500 email addresses, which i need to find out if
any of the providers are the same. after the @ symbol.
So imagine 500 of these addresses, most with different provider, but

Is there a way to return the cell reference, or column/row coordinates,
of a cell within an array or table by providing lookup criteria?

the Max() function will allow me to capture the maximum value in a
column of data.
Is there a similar function for text?  Example:  I have a Projects
Status file that contains varioius data about the project and a color

i have two excel files. test.xls contains some information i want to
have uppdated to fredrik.xls
this works in test.xls
='U:\tmp\[fredrik.xls]Blad1'!B10

I'm using Excel 2003.  Anyone know how to get it to stop automatically
choosing a data type for my columns?  Some of its automatic features
are nice but its auto data type sometimes gets in the way.  Example, I
run a program which exports data to Excel.  The data contains fractions

is it possible to have vba code in workbook ehich would do:
Workbooks.Open Filename:="D:\somefile.xls"
'and then
run Sub one - this I have no clue how to make ?

I have a workbook with 2 worksheets.  One is a cover sheet with a
variety of VLOOKUP's that reference the second sheet, which is the
data collected.
I am constantly getting new data in from outside sources, but luckily

I've run into a problem I don't understand using power functions. I've only
done limited work with powers in Excel, but I've run into a problem with
this formula;
=(-0.01^ (2/3))

Wondering if anyone has run into this error. I have a large spreadshee
(7.7MB, 41 worksheets). I just starting getting this "too many cel
formats" error. Is there any way around this... maybe a parameter tha
can be changed or something?

I have a list of email addresses in an Excel column that I would like to
copy into Outlook Express. Is there a way to do this?