I have one employee NOT working 8 hours sometimes.
Monday 08:00 - 16:00 = 8 hours
Tuesday 08:00 - 15:00 = 7 hours
Wednesday 08:00 - 16:30 = 8,5 hours

Is there a way to 'turn off' the prompt "Do you want to save your changes?"
when you close excel? Many thanks for any help!
Dawnyanne

How does one custom format numbers > 0 to appear with a preceding "+" (plus
sign) ?
Thanks

Hi to everyone in the newsgroup,
Does anyone to known how to sort a list by starting from any
alphabetic letters?
For example, if I chose "M", I'd like to have the entire list starting

Is there any way to add up the number of people assigned to a specific area
on a rota AND at a specific time, so for example if on the rota I have 3
staff down to work on tills before 5pm and 6 staff on tills after 5pm, is
there a way excel could count through a range of cells ...

Ladies & Gents,
Hopefully my example below is not confusing :)
In essence I have a table of 13 columns and 200 rows with a purpose of
recording course details people attend.

we created a spreadsheet for our kids grades, ie.  
we show quiz 15%, homework 10% and tests 75%.
how do we average and weight the grade (and show the formulae) if there were
no homework grades.

How can I get a count of specifc words in a range?

I'm trying to set up an "if" statement that says if a cell equals "no" to
enter a question in regular text and then display the possible answers in
bolded text right afterwards. I think I remember seeing it somewhere, but I
can't remember how to do it or if I'm thinking of ...

I have 5 columns.  First 4 need to perform arithmetic functions and the last
column need to perform like a table cell ie can type a few lines, left
aligned.  I can have tried wrapping but alignment get messed-up when I
change the column width.

How can I permanently set all the margins so that I don't have to change
them everytime I open a new excel file?
TIA

I have a column of dates like below in cells A1:A11.
10/04/2007
21/08/2006
10/04/2006

I have a 5000+ number list within a spreadsheet made up of 6 digit order
numbers, if an order numbers 'order' contained multiple items then the number
appears x times in the list, once per item.
I want to pivot the data, but need to extract a list of order numbers with

My data sample:
aaaa-@345-1111.txt
aaaa-*5#8-2222.zip
bbbb-0987-2345.dat

I'm new and trying to maximize a shipment with certain parameters.  I have 6
products differing in weights (5,4,3.5,3,2,1) each with different costs
(9,8,7,6,5,4) and sale price(17,13,11,9,7,5).  I can only send a combination
of 3 products lines with 4-8 pieces of product and ...