Hello, I am having an awkward problem, on every sheet I use(Including
new ones)..
When I enter 100 it changes it to 1.
When I enter 1000 it changes it to 10

We have a spreadsheet that has lots of rows in it.
However each time we use it only some of the rows are filled in under one of
the colums.  If a row has that particular cell filled in (not null), we want
the row printed out in the report or printout.  What is the best way to do

I am trying to create a customer database using Excel.  
Under the first tab I would like to be able to enter a search criteria
into a box.  It should search in the any of the fields being maintained.
It will then present a list of possible options from the search.

I'm making a mortgage lending database system for my GCSE ICT coursewor
and I have a field in the database called ID Number...is there any wa
of making it a unique field i.e. no two values can be the same- an
sort of validation or anything?

I want to use Excel to compile a list of my DVDs.
This requires just two columns. The first column will be used to number the
DVD. The second column will be used for the actual name of the DVD.
However, I will want to sort the list in two ways: alphabetically and

I have a "TODAY" value that changes everyday.  I want to convert that to a
"DATEVALUE" that changes with the day.  I need a value that equals today that
changes with the day.  I do not want the date only to change but the value of
that date as well.

I have a spreadsheet that calculates age I need the "Today" date to be
converted to a new value automatically every day.

Hello Fellow Excel users,
I have alittle problem which i hope somebody can point me in the right
direction
Picture my screen in excel

In access a combo box can have two or more columns.
Is this possible in Excel.  If so how ?
Stuart

I see the need to use 101-111 for Subtotals; e.g. I want to ignore hidden
values.
But, I don't see why I want to use Subtotals 1-11, instead of using the
built-in functions like average, count, max etc. directly.

I can't seem to firgure out how to set up the following argument in an Excell
spreadsheet!
IF cell B-6 has the value of "C" than cell J-6 = .8*H-6 and cell I-6 = .2*H-6
IF cell B-6 has the value of "P" than cell J-6 =SUM(H-6-E-6)

Hi Experts;
I need to make a report of first login & Last logout time.
Please help me.
Sample Data:--

Assuming I have a workbook with many worksheets and I want to search for
a particular word contained in one of the cells, in one of the sheets
somewhere in the workbook, how do I go about it?
Please help!

I wonder....
Why does my graphs go blank when I hide the cells containing the source
data?
Is there a way to omit this annoying occurrence?

How can I get 1 to show up as 01 yet still be considered a number?  I can
only get it to show up as 01 by changing the format to text.
I want a list like this:
01