Can ne1 help me with a formula please.
I have a payment shedule which shows how much people have paid off a certain
amount. I want the columns underneath to show a "0" value if the amount
outstanding is above 1. Cna ne1 help please. TY

I'm makeing a spreadsheet dealing with money and I forgot how to make it
so that if a number turns up to be negative it becomes red. Can someone
remind me?
---

How would you format a cell to reflect military time???

(Excel 2000)
I have a point tracker for everything I eat (yes - I journal everything).
I would like to just infinitely add items under each day.
Example:

In the PC version of Excel there used to  be an equal sign on the formula
bar to rapidly change a number into a formula for calculations and stuff.
Now it¹s gone. Someone knows how to get it back there?
Thanks,

I've coded a big spreadsheet application which has more
than 100 worksheets and 10000 lines VBA code. I have a
question which need some expert to give some insight:
I set a validation on cell "L12" in worksheet "S2". The

I am using Excel 2000 for invoicing. I would like to freeze the
current date so that when I reopen the workbook it shows the date the
invoice was created.
I can use =now() in the cell and then a macro to freeze the date.

Sorry if this question was asked before.
Lets say in A1 I have a formula =B1.  It means the content (or value) of A1
equals to content of B1.  Now, lets say I want the value of A1 be equal to
some cell in column B, but not neccesary the first.  I want to be able to

I hope someone will help (sorry to ask again if these questions have
already been answered in this forum).
In a workbook, I use ?x? similar worksheets in which I use the
following for each worksheet: D25:D38=a date, every two rows (can be

Would appreciate some help in finding a suitable formula.
I have 2 spread sheets. Spreadsheet A is full of data, and Spreadsheet B is
where I wanted the search results to be, say, in cell C1. A1 has a Salesman
name, B1 has an item name.

I AM USING THE FORM TOOLS TO CREATE A PRINT DIALOG BOX. IN
THIS BOX I AM HOPING TO PRINT SHEETS IN THIS WORKBOOK. THE
CATCH IS, I WANT TO HIDE THE SHEETS. IS THERE ANY WAY TO
DO THIS? I AM USING OFFICE XP EXCEL.

I have a sheet which lists customer complaints. Each row is a different complaint and has a cell for "Closed date".
Is it possible to have the values from the entire row or a range of cells within that row move to the closed sheet when a date is entered in the closed date column?

This is an easy one but I am having a hard time getting the synta
right.  I have three sheets.  In column A of each sheet are SSNs.  
want to do a Vlookup of Sheet3 Col A on Col A of Sheet 1 and Sheet 2.
If I encounter an error on the VLOOKUP of Sheet 1 I want text messag

Any ideas how to sort a column of figures so as to
separate odd numbers from even?

How do I change a positive integer that has been entered
in text format to numeric format?  I can go from numeric
to text, but not from text to numeric.  Thanks.