I want to create an automatic renewal for calcualtion of depreciation
after x years. To explain
this is what I want it to look like. I want a formula for this
No; of Years   Year 1  Year 2   Year 3    Year 4   Year 5...... Year 30

I was able to import my text files into a spreadsheet, but here is what
I need to do next and I hope there is an easier way to do this through
the program.  Her is what I have, I have a product spreadsheet that
includes item number followed by the description.  the item number is

i make my sheet font size to 8 but why when i enter text in my text box, the
font size larger than 8?
where can i define the font size so that it also 8?
thanks

Is there a shorthand increment operator ?
eg something like  :
    Inc(long.variable.name)
which would be easier to read than

We have four shifts that rotate between days, swing, and graveyard.  There is
always one shift off.  We also make a variety of products and lengths (each
day the production schedule changes).  Right now, I manually fill out a punch
sheet representing the day's production and I am ...

 Is there a formula to take a currency value in one cell and have it spell
out the amount?
     If in one cell I have $28.32 is there a formula to have it put in
Twenty Eight and 32/100 like in a check?

I have a mileage form that in col C list multiple cost centers and in col D
the user has to enter their cost center again so the calculations will work.  
I'd like a formula that will pull the cost center in C only once so there is
a total of mlg being claimed per cost center.  

I was given a spreadsheet in millions and I want to convert all the numbers
to thousands.  (ie $1,538,498 to $1,538)  How do I go about doing that.
Version = Microsoft Excel 2003, SP2
Thanks,

Ok lets make my question more clear..
In column "A" I have Supplier, or CFAC, or EM&T.  In Column "D", I have any
letter A through Z and any number 1 through 9.  
If I want to count everything = to "Supplier" in column A that have and "E"

Is there a function or command for a cell in a worksheet that results in a
search of the entire Excel workbook and which then returns (in the worksheet)
the full value / content of each cell in the workbook that matches the
criteria of the search.  For example, on one worksheet I ...

Why would this happen?

How do you make Character "B" Bold
Sub BonusNumbering()
Dim cell As Range
Dim lRow As Long

how to calculate 5‰ of 1250 with MS Excel?

Here is the formula that I am using.
=VLOOKUP(G7,$G$70:$H$89,2,FALSE)
   It works fine but I want the cell accepting the
result (G8) to be blank when G7 is blank.

I am filling text into a cells by using
Data--Validation--Lists.
    This won't let me enter anything in the cell that is
not on the list.