In using Excel, a small green triangle has appeared at top right corner
of some cells which
contain a formula. The formula works, but am puzzled about this.
The version of Excel is from Office 2003, can anyone explain this, I

This is probably really simple but for some reason I can't figure it out.
Here is the problem I have one cell that contains a long ID#
And one Call that has a quantity and I-d like to show a range of values
based on that quantity but only display the last few characters

    I thought I found the fault but I still can't get it to work! I am
trying to copy sheet called "inventory" to a new workbook save it with
the name of the value in cell X4 and close it  and return to the
original workbook. Thanks for any help

I'm trying to set up my worksheet so that if the value in column E is
changed to 100%, the value in column A of that row automatically changes to
100, regardless of its original value. At the same time, I don't want to
lock down column A - the user can enter any value in here when E ...

I have word data in 2 or more collums (not cells). When I copy and paste that
data into a cell (word or excel) all that data goes into one cell. How do I
get the data into the respective cells without going back and cut from one
cell to another?

I have a spreadsheet at work that will create a formula
after I fill the cell needed to finish the calculation. I
want to know how to do this for my own personal use.
Someone please email me with a solution to how this is done.

if i have 20 worksheets in a workbook, how can i use find
to look through all sheets instead of going into each
sheet to search.#
thanks

I'm working on a sheet that I have set up to print in landscape format.
which is just what I want for the first 12 pages... but I need the next two
pages to print in regular Portrait format. This is all in one sheet. Is
there any way to do that?

XL2k,sp3
I have 12 worksheets in a workbook that is book and sheet protected for many
reasons. Is it possable to unprotect / protect ALL sheets at once, to allow
maintenance/upgrade's to the cell contents? Certainly would make it easier

I have a LONG price list (about 4 columns each and roughly 10000
items) that I am trying to publish 3 or 4 columns per page.
I am using Excel 2003 - is there any way to do this or do I have to
port the whole thing over to Word? (Aaaack!)

i want to convert multi decimal place data to 2 decimal places including
showing zeros. Old excell used currency formula- cant find how on latest
office.  Help

I am using Excel 2000. I have made a W2 form that I need to copy and paste
for a total of 80 copies. ( I made the form just through using cell borders
and resizing cells etc.)
All of this is being done on the same worksheet. Through cell protection the

I posted in another group but I don't think they understand what I am
saying.  Maybe you can assist me.
I am using a template that is in xlt and in the shaded column I need the
formula in L20 that is =if(D20<>"",D0*K20,"") I get an error stating that

I have a form where in one column of cells, either Y or N is supposed to be
entered.
Is there a way to convert a "y" to "Y" so that they look a bit tidier? This
conversion would occur automatically no matter if they entered a "y" or "Y".

    When I run my macro the code below is the last part. The last line
before the "End with" is where it gives the " Run time error 9 Subscript
out of range".
Everything appears to work ok right until I try to save the file.