How can I format the result of a simple formula to give the result rounded
to the nearest 10? Example, 1178 displayed as 1180 (no decimals)

I need to calculate a specific value everyday at specific hour and I don't
know how to concatenate the time to the TODAY() function.
example:
I added in A1 the TODAY() function so that gives me 8/10/2006 and I have in

I am trying to create a spreadsheet to keep track of employee's bonuses
and awards.  So I have three worksheets in a workbook.  1st worksheet:
Awards, 2nd worksheet: Bonuses, 3rd worksheet: Budget.  Awards and
Bonuses both have monetary value.   On the budget worksheet I want to

Hi, I am not "fluent" in Excel, so please make any answers "dummy" level.
I have a running balance column that spans multiple pages and I am trying to
get the last balance from the previous page onto a cell in the following page.
Additionally, there are column headings at the ...

I get the notification "Not enough system resources to display completely"
whenever I try to open a fairly large (4MBytes) and complex (tons of
formulaes)Excel file. The file is opened but the display is garbled. I have
created this file over a period of time myself, so now ...

I want exel to automaticly add comas for numbers greater than 999. How do I
accomplish this?

Hello group,
I've worked with excel for many years, but I could use some help throwing
this together.  The background:
I have two sheets within the same workbook.  One sheet has check numbers and

I have a worksheet of raw data.  One of the columns has 3 unique
values...either 1, 2 or no data at all (NULL).
Without inserting some value in this cell, is there some way of doing a
Subtotal of all 3 of these values.  At the moment the grouping that is done

I have a workbook created by someone else with about 50 different sheet tabs.
Each tab is a part number.  I would like to organize them alphabetically but
it is quite a chore since there are so many.  Is there a macro I can use that
will automatically put them in alphabetical ...

I'm setting up a worksheet to keep score for volleyball matches. The teams
switch sides when the score total for both teams reaches multiples of 7 (ex
7,14,21,28,35,42,49,56) Is there a way to format a cell to display the
multiple in red? I've tried "Conditional Formatting" but ...

The formula causing me fits is "=DSUM(Grants,Grants!$E$10,C74:D75)*12"
(without the quotes); it's from a budget worksheet I'm adapting for our
org's use.
I keep getting a "#VALUE" error.  When I simplify it down to retrieving a

I developed an application for Excel that uses "Rows to repeat at top" (for
the header in a table) in the event the report being printed has multiple
pages. It has worked fine. However, a user recently reported she has a
report with just one page and is getting the header (the ...

I have a table with field labels in column A (A2 to A16). I'd like to rotate
this table clockwise, i.e. have the field labels on the top of the table in
A2 through I2. I tried to build a PivotTable to no avail... Does not matter
what I click on or highlight in the original table ...

I have a list of numbers in column A. I wish at the bottom to return the
maximum value in column A using =max(a1:a100) but i also want the cell
reference of this value. how can i do this.
thanks

hi members,
is there any way in excel through which i could get page total
particularly without using vba or macros.i have 950 pages in my data.