Is it possible to have Excel automatically wrap text as required in any cell
of a worksheet, instead of copying formating to individual cells?

I am using this macro for naming my tabs with the content of cell A1 on each  
worksheet, my problem is that it wont work with a date, and I need to have a
date in cell A! to name each tab with that date. Any ideas would help.

one the numbers are as follows;
1303.54*1*2.8%/365
that is I9*J9*D7/365
it should turn out to be .09

I suck at this so be patient1
I'm trying to calculate interest using the formula
balance*days-since-last-translation*interest rate/36           I9*J9 *D7/365  
I think its not working because d7 is formatted as  a percentage (2.8%).

I was wondering if there was any way to create a formula that references the
last cell with a value in a column.  This excel worksheet we have is updated
with a new value for the 2007 column every week, therefore we are just copy
and pasting our simple formulas one cell down each ...

Hi there..
I have two sets of data side by side in one worksheet. All the same
fields but one set of data has the more records than the other.
My aims is to display only the records that existing in each set.

Looking to change the format of an object...change the color of a circle to
red if less than, yellow if between two values and green if greater than a
value.   I can use condiitional formatting in a cell, just wondering if
A) you can apply condiitonal formatting to an object

I would like to set up a data base for photos where the picture being
described is accessable through a link if that is possible. I use office 2003
and I am planning to use Excel if it is possible.

How do I reference the cell above the last cell in a column??  I know how to
figure out the last cell, but I'm not sure how to subtract the last cell by
the one right above it.

Is it appropriate to use area type for breakeven analysis?

I have this formula and it works but doesn't meet my requirements. The result
is entered into column AL15
=COUNTIF(D15:AK15,"X")*20
I need it to read two columns every time before giving the results in column

When I apply borders to my spreadsheet and then I move cells from one
location to another, the vacated cells become Borderless.  Is there a way to
Retain the Borders in the vacated cells w/o having to reapply the borders?

How do I find an entire list of all Excel 2007 Training Courses?  I get a
list of different courses depending on whether I enter Excel 2007 or, for
example, Charts II into the training page search engine.  Any help would
certainly be appreciated.  

i need to place to sets of information in the one cell how do i split the cell

When I open a DBF file in XL2003, deleted records are not imported. Is there
any way to import also them into Excel (without making them first undeleted)?
Thanks,
Stefi