I have the following formula which I want to format to 0.0% and am having
difficulties doing same. Without the formatting it is the following and
works
="Sales are

I have 2 large data bases that change in a small way each month. One has an
extra 2 columns which never occurs on the new DB. Only the account number is
consistant. How can I check each for changes and merge only the new dats into
the batabase?

How do I create a formula that will pick the furthest right non balnk
value in a row.  The colums represent the months of the year and every
month data is entered in the row.  Sometimes the cell will be blank.
ie

I have numerous people with varying compueter skills using Excel on the same
computer. Frequently, the formula gets inadvertently changed  during the
day. I would like to know how I can prevent this from happening. I don't
recall which version of Excel I have (I am typing this ...

I need to set whatever indicator or key used by Excel that tells it a
workbook has been changed and prevents it from closing without asking if
I want to save it.  Some of my macros make temporary appearance changes
to the workbook that I do not ever want to save and I would like ...

Is there a way though VBA in one command to put a range to an array.
E.g.
strArray()=ExcelRange.Value
This does not work for us but is it possible without looping through the

With the function  =COUNT.IF(a1:a10;"<10"), i'll get the number of cells
with value less than 10.
But suppose there are cells which contain the text value "<10" (as a code
e.g.). How can i use COUNT.IF() function to count the number of those cells?

I am needing to label my columns in Excel with a word....how do I bypass the
alpha labelling system (A, B, C, D, etc needs actual column names, not
letters)

I own several Excel files located in the organization's network.
I want to keep a master copy in my laptop for offline updates.  Then when I
connect to the network, it automatically updates or synchronizes the network
version for others to use.