There is a given value 68 in cell A1, I would like to determine the value
based on following conditions.
Sqrt(68) = 8.24621, and the rounddown to the closest odd number, which is 7,
and return this value in cell B1.

I have put in the start time 09:30 and when i quit working 18:15 and made a
formula =SUMMA(D4-C4) so that i get how many hours and minutes i work that
day. But how do i add all hours and minutes for each day so i can see how
much i worked whole month?

in pivottabes i have a row of names with the relevant customer spend shown
alongside. there is the sum total shown at the end.. how can i create a
column that reflects each customer spend as a percentage of the total....
thanks in anticipation

hi
i have pivottables that are referencing data from a worksheet in the same
workbook.
as i am adding data constantly to the worksheet how do i change the data

customer PC having the System to reboot.

For some reason a function is calling this:
Worksheet_SelectionChange(ByVal Target As Range)
I don't want it to call this function.  Is there a way to make it so it
doesn't call this function if there is a selection change?

I have a workbook with sheets named 2005, 2006, 2007.  Each sheet contains
data that matches the paychecks that my wife and I get.  Each column is a
paycheck.  I have another worksheet called STATS.  On this sheet, I have a
form for each year (worksheet) that pulls totals from ...

How to separate excel formulas? I want to keep all my excel formulas as a key
value pair either in flat file or in database, and link those formulas in my
excel cells.

I have inventory spreadsheets on Excel that I would like to merge with
Publisher in order to create price tags without all the data entry.  I have
one field on the Excel file that needs to be merged (not the whole document).
Any tips?

How do I change the font size of the letters and numbers. The letters at the
top E.g. A,,B,C,D,E,... and the numbers on the side e.g. 1,2,3,4,5,6,7,...?

How do you modify the keyboard short cuts, e.g., change INSERT ROW  from alt
+ R to alt + I

How can I get the number of COMPLETED months returned between 2 dates?
At times it may be grater than 12 months - but never greater than 24
months.
I've been fiddling with  =Floor and =Ceiling but when the dates are in

i have an excel which has 3 sheets and i have been updating it with stock
information.....its size from then until now use to be between 500kb to 600kb
but recently the same file size has reached until 10mb .... i scanned for
viruses but found none....it even takes time to open , ...

I have saved a file by auto recovery. But I replaced the original file with
the recovered file. I want to see the details of the original file. Can I see
the original file, which is modified on 22/12/07.

I'm trying to uncheck all the check boxes using a macro.
Private Sub Clearall()
Dim ws As Worksheet
Dim chkbx As OLEObject