Hi there,
How do you get excel to see a number written in a box as a number, and not
in mmm-yy format as default. For example, when I open excel as a new sheet, I
will type 2000-10, and it will auto format as oct-00, and in the tool bar it

I am looking for a formula/function that will compare the data in each
cell in Col A, for example, with each cell in Col B, AND vice versa.
There would ideally be some output to Col C that would alert me that
there is an entry in Col B that is not in Col A, and vice versa.  (It

In one cell I have numbers and alphabets and how to arrange ascending
or descending for example
before
Cell A1 = 6532ADC

I have multiple rows of data with several columns, each row being data
on a specific customer.  I want to copy several cells of data from a
specific row in a sheet to a different sheet (within same
spreadsheet), the purpose being to isolate some of the data for a

I created hyperlink from a cell to a word document in the same folder.
However it does not work
Any possible reasons
Afd

I am bewildered though it doesn't take much to bewilder me when it comes to
computer applications.
When I worked in an office on the computer all day creating spreadsheets in
excel

In an excel workbook, I have created for my users a configuration
worksheet, nothing special, no formula, no VBA only some dropdown
menus that's all. The problem is that this worksheet take ages to load
when I open the file, copy paste values, to scroll down give me the

Excel variable for path
I would like propose a variable in an excel cell and launch a wor
document from other excel cell
Y:\document\%variable%\proof.doc ,

I'm trying to search all records in column A across all records from
column B through F.
the terms in column A will be substrings within B through F.
CountIF does not return all results of the substrings, and referencing

I'm trying to calculate the weighted average interested rate for a subset of
the loans in my table. For example, only loans for the month of May.
I can easily calculate the weighted average for the entire table:
weighted average =