When I sort some data and hide rows or columns formulas are calculating using
the entire database (including hidden rows).  I'd like to calculate only
'visibe' data.

So I have a column of zip codes - some with 5 numbers and some with 9.
What I am trying to do is create a formula where if there are more tha
5 characters in that cell, insert a "-" after the 5th character from th
left...does anyone know how to do that?

While using excel worksheet how can one convert numbers in one cell to
figures in other cell like the function 'bhattext'.?

Can you set the 2nd parameter of VLOOKUP so that it looks at the tab
according to the cell
e.g
VLOOKUP(A1,STRING!A:C,3,0)

I need to find a way to use VLOOKUP in VBA.  Using the formula in my
spreadsheet won't work for me.  Users will enter data in cell A1.  If it
matches data in another list elsewhere, VLOOKUP will autofill A2 and A3.
However, if it doesn't match any other data, users must manually ...

This is my first time.
Maybe some one has opened this topic already.
How do I automatically convert digits to text for example 1234 as "One
thousand two hundred thirty four". There is a command available as

How do I create a read only file on a network drive that I don't want users
to be able to copy, save as or print this file.

My store uses a retail price "code" wherein a price like 99 in expressed as a
code like "PP"--exchanging the number digits 1-0 as letters.
Is there a function to do this automatically?

I am trying to get relative reference to work while using my macros.  The
help menu says there should be a pop-up toggle switch that allows me to
select between absolute and relative references.  That button never appears.  
Ideas, please?

I have created a drop down list in an Excel file.  I set it up for a cell to
refer to to the list via Data - Validation, but when the cell is chosen, the
drop down arrow does not appear.  It has worked for months but it has now
stopped.  I tried to delete it and re-create it, but ...

I have a problem, i have a formula in one worksheet wich gets data from
another excel file: =+'C:test.xls]Worksheet1'!A8
The worksheets in the two files are exactly the same so my question is
can i replace Worksheet1 in the above formula so he takes the current

I have a main Word document that has links out to several Excel files.  They
work fine, but the return links from Excel back to Word always go to the top
of the doc.  I need the return back to Word to bring the reader to the spot
of the orignial link.

I'd like to base a COUNTIF calculation on the rows displayed after an
autofilter. I've been trying combinations of COUNTIF and SUBTOTAL without
success.
Basically, I set an autofilter on column-A then perform a COUNTIF on

I have a spreadsheet that has several columns with dates - Today's date,
yesterday's date, etc.  If a new date is typed in, how can I set the
spreadsheet to automatically insert a column for the new date?

I want to know the order of calculations, meaning whether cells on sheet 1
are calculated before sheet two, and within sheets whether calculations are
done row by row or column by column. Or is Excel smart enought to work out
all dependencies for the entire workbook and figure ...