I have a worksheet that will not have dates entered until applicable and I am
trying to have the formulated cells remain blank until the date is entered.  
However at this point it is showing 1/5/00.
Any suggestions?

I am creating a timesheet that I need to track daily logs of employees time.  
We have codes and mark in half hour increments.  My problem is that I would
like to do this all on the computer rather than by hand and when doing it by
time and code I don't know how to create a ...

I have a spread sheet with some 15000 lines in it. One of the formulas in my
sheet has been chaged from top to bottom. It is caculating for the incorrect
rows. I need the formula to be changed back so the formula reflects the line
# it is on. How can i change this without having ...

i know it can be done wid conditional formatting but not sure how.

I want to be able to plug in a gross sales number and have a formula spit out
the amount of commission to be paid to that sales person.  However, their
production is tiered and they get paid a different commision based on the
level they are at, for example the plan is as follows:

Is there a function that counts the number of cell references in a formula?

I am trying to move create macro that will move cursor down one cell.  the
range select function does not meet my needs.

Is there a limit to the number of named ranges? I am running into
errors now with my large (large) workbook here, which contains a ton of
named ranges just to make things easier for me.
For instance, a simple formula such as this:

I am using the macro recorder and have it turns to RELATIVE recording rather
than ABSOLUTE recording, but... I cannot figure out how to record navigation
keys relative to my current location.  For example, when I press the HOME
key, I want the macro to just go to the far left ...

I am trying to use a header that says Bldgs E & F but the & sign keeps going
away and only keeps the E F is there something i need to put in front of &
sign to make is stay???

Hello to all,
i have following problem.
I have a pivot list which obtains data from an access database.
The result is an excel report which states

I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?

I need a formula that will detect the presence of a value in an unsorted
named array.
Column A would be the named array.
Column B would be the value I want to test for.

I would like to be able to change a positive number to a negative number and
vice versa by formatting the cell.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

We work with over 200 password protected files. These are not shared files.
We have had a problem with one of our files where all of the worksheets
except one are not protected any more.
But when I go to the tools menu - It shows Unprotect worksheet and asks for