I'm using the TODAY function to put today's date on an invoice, however I
want to prevent the field updating if I open the worksheet in the future. Is
there any way of achieving this?
Jeff

Does anyone knows how I could select/jump to a specific row?
ie.  I just open a file contains more than 5000th row of data, and i
would like to jump to the 700th row, is there a way to do that?
Thanks.

This formula is in L22, It references MERGED cells: D&E, F&G, H&I, and J&K.
If there is input in any but not all of the merged cells I get the row
incomplete message, but once all the merged cells are filled the message is
not shown. I understand the theory but where does the "AE" ...

How would I go about changing colors within a formula.  What I would
like to do is as follows.  As example, formula would be in cell H37.
If G37 > Now() and I37 is < 100%, then "RED" else "GREEN"
Where text indicated is RED, then I want the font black and the

Is there anyone that would now of a formula that i need to bring back a
value of total the way i have my sheet set out is
B4=Name, C4=Manager,=D4=Date From,E4=Date To,F4=No of Days,G4No of
Hours,H4=Sataus

hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated:
=EOMONTH(DATE(YEAR(Model_Start_Date)+1*(MONTH(Model_Start_Date)>MATCH(Per_1_End_Mth,LU_Mths,0)),MATCH(Per_1_End_Mth,LU_Mths,0),1),0)

I've got a worksheet with four columns, one of which is a user name. I
would like to take all the user names that contain numbers (and their
respective data) and put it into a separate worksheet. So far, I
haven't had any luck doing this with any combination of wildcard

I want to use a date field to produce an invoice number.
Can anyone tell me how to enter a date in a date formatted field e.g.
31/12/06 and have "061231"  appear in another cell, but formatted as text?
(It needs to be text because my next stage will be to add the first three

Hy,
I use MS Excel 2003, and recently, I cannot insert ActiveX controls, such as
button, combobox, aso... on an Excel sheet.
As soon as I selection tools from the toolbox and click on the sheet, Excel

Is there any way of automatically generating a (Save As)  file name from the
contents of a cell?
Jeff

I have a protected worksheet. How could I copy and paste within the
same worksheet without unprotect it? Any help will be highly
appreciated!

OK, before you state the obvious, Auto Calculate is "on", I've tried Calc
Sheet, Manual & "F9", "F9" in Auto, switching between all four, closing and
reopening the file, rebooting, etc. The cell containing the formula is not
formatted as Text, the formula is fairly simple:

I understand that there is a function (CONVERT) that converts feet to inches
and vise-versa.  BUT is there a modification of that function that will
convert inches to a COMBINATION of Feet and Inches?  (ie: Convert a value of
67 to 5'7")

Wehn I enter "October 10, 2006" into my excel spreadsheet, it always changes
it to "10-10" or something like that. Where can I set my excel spreadsheet to
display the full date?
Also, does anyone have any experience with Google spreadsheets? Any good?

I am new to excel.  I am doing a catalog using excel.  One row has item #,
another size and etc.  I can get the information to paste into my web page,
but all I get is the information.  There are no lines "gridlines".  I was
told to use a border and this did not help.  Please let ...