Can someone please run me through the drill to configure Excel 2002 to
always save a backup file when the original is saved.
Thanks,
Ron Patterson

Trying to get a column to auto-format numbers based on value - I've
done some Google searching, checked through newsgroup archives and
must be looking in the wrong place.
I have a variety of numbers from $146.0B to $.0093B using a Custom

I need a macro that will check out a given range( say a1 to z100)
As it checkd ther range(a1..z100) if there is NOT data in the cell, replace
the blank cell with $0.00
I appreciate all the help I am getting from this site

I run Excel 2K
I require a formula that removes the last 19 letters from a text string.
I have a number of varying lengths of text strings that require the last 10
letters being removed from each them.

I use VLOOKUP all the time but I now have a workbook with multiple
worksheets. Each worksheet has different product groups. Each product has a
unique product code (catalog #). I would like to retrieve three pieces of
data.

I have 3 columns that I would like to be merged in to one. For example:
b2=3 c2=4 d2=6, and so e2 = 3
                                    e3 = 4
                                    e4 = 6

I am working on invoices for my employer. Each row in the spreadsheet has a
calculated value. When the calculated value in the row = 0, then I am to
'hide' the row. If the calculated value is not =0,  (could be positive or
negative), then I am to display or 'unhide' the row. Does ...

I have 2 lists of students - both lists are exactly the same; in one list
certain students have a grade, in the other list all the other students have
a grade.
No student has a grade on each list; how do I end up with one list of

I have 2 pages
Page 1 is booking form
In page 2 I am doing this    ='Booking Form '!J11
This refers to a name on the booking form, however it shows ='Booking Form

Hello - I have a server inventory list that I'm trying to organize for
end users based on what group the servers belong in.  Some servers
belong exclusively in our "Staging 1" environment, some servers belong
exclusively in our "Staging 2" environment, and some are shared

I have a worksheet with about 2,000 records. I have a status field with 3
possible values - Open, Closed or Void. I have about 25 records in this
worksheet with a status of void. How could I copy ONLY those records to a
second worksheet? If I could do this automatically, this ...

My new version of Excel is acting very strange.  I will highlight a
cell to input data or a formula, but once I start typing, the focus
cell will shift 20 cells away.  In other words, it won't enter the
data into the cell I selected, but it will input the data in a cell

I am thoroughly confused! Over the weekend (and now of course) I posted
questions in this “area”.  When I got to work this morning and started
looking for the posts, I found that at work I have set my favorites to look
for Excel questions in an “Office / Community”.  I now know ...

I have a worksheet which has a bunch of formulas in rows (i.e. data entered
in columns C through F result in formulas results in columns G through
whatever).
All I want to do is to copy a row and move the formulas into another

I forgot to mention that although I can get Aotofill to use the correct time
increments, it inserts in every cell, not in every other. Thanks again.