How do I preserve the same formatting ie: $ signs when using the
formula "+" between worksheet pages? I want to preserve the dynamic
functionality so if someone inserts or changes data on the "DATA"
sheet, the "DAILY" subsheets also change. If I COPY the data from the

i am working on updating a spreadsheet i am using, and would liek it to
update with invoice no's such as:-
='S:\2005-2006 Sales\Invoices\[17142.xls]Sheet1'!$B$11
where 17142.xls is the other spreadsheet i want to get teh data out

I am writing a formula to calculate the last and next month end e.g. if I
enter 28-02-06, the expected result will be liked 31-01-06 and 31-03-06.  
28-02-06 will be stored in cell A1, and my expected result will be displayed
in A2 & A3.  My formular is liked " =A1-31 , = A1+31.  ...

My formula is SUM(B2:E2)-G2/G2 ... numbers are (7.58)-10.29/10.29.
Correct answer is - 0.2633 but Excel keeps inserting 6.57 as the answer.
Please help ... trying to calculate Total Cost on ALOT of spreadsheets.

Can anyone help me with this:
I would like to set up a sheet so I can type a number in the A1 cell & a
Sales Rep's  Name will appear in B1.  I am working on creating quote sheet
for work and I want to be able to tie numbers to specfic descriptions.

Okay here's a challenge (well it was for me!)
I am creating a staff planner and need to count part-time staff hours.
the data that is entered has two variable
a7.5

I would like to be able to use a cell reference, in a formula, that points to
a cell that contains a Range Name.   I hope I've stated that clearly.  Just
in case, I'll give my example --
I have a table in which I've created many lookups, all of which look to a

For example I have the number 5 in a cell and need to change it to the word
five.

In column A and B I have text representing an Entity and its Intercompany,
respectively.  In column C I have concatenated the two.  So now in Column C,
for example, I have "BillTom" in row 1 and "TomBill" in row 900.
I need Excel to convert the text into some sort of code, ASCII ...

*One final problem and I’ll leave you alone….
Excel 2000
If (E10) is greater than 11 “full time”, IF (E10) is greater than 8 but
less than 12 “Three Quarter Time” IF (E10) is greater than 5 but less

I am trying to list my old 45 records Alphabeticaly. I would like to enter
them and get Exel to sort them as I enter them. Can any one help.

I am setting up a workbook that has cell formulas linked to data in 2 other
workbooks.  I want to know if there is a way that I can sort the data in the
2 source workbooks while maintaining the correct linked cell formulas in the
destination workbook? (when I sort the data in the ...

How can i change text 2/27/2002 12:00AM (cell F2) into this dat
27/02/2002 ? (cellF3). Also 11/27/2002 12:00AM into 27/11/2002
Thank
--

I have a column of numbers and want to color highlight the lowest number in
the column.  However, I only want to color highlight if there is a clear
"winner".  Ties should not activate the color.  There is a posted article on
the MS site (article 909845) using an IF statment but ...

Working with a large spreadsheet.  I will engage Autofilter and want to add a
section at the bottom for subtotals pertaining to the filtered data shown.  
What formula(s) would I use for that since it would change for each filter
selection?