A colleague of mine has to sort out library numbers of children at our
school. This involves allocating up to 500 numbers individually for each
child. The system has been working for a number of years and each year he
has to delete children who have left and re allocate their ...

I reinstalled Office 97 to fix a problem with MS Access and now my
custom toolbars that I made in Excel have disappeared. On a happy
note, my Access problem is fixed. LOL  I searched for *.xlb files and
didn't find any on my hard drive. I searched an Image backup of C

I'am trying to set a multiple shift weekly work schedule for 55 employees.I
thought drop downs for each employee and for each day, with the drop downs
containg all shift times would work the easiest to quickly set up schedule.
Having trouble setting up, need step by step if ...

I am wanting to create and design a dialog box to open up in my workbook in
excel but cannot remember how to start. I would be very grateful for help on
this matter.
Cheers

I get that Deer in the headlight look, just thinking about this.
I need a formula if it is feasible:  1.0 Mbs through 1.5 Mbs = 1.5M, 5.0 Mbs
through 100.0 Mbs = 100M, 101.0 Mbs and higher = current value minus the .
space. Just the M after last number. Exceptions are: 45.0 Mbs = ...

I am trying to make a time sheet that automatically calculates regular time
and overtime.
 B              C               D             E              F              
Time Worked    Total     Reg     O/T

When i press CTRL + BREAK a msg comes on the screen.
I made this by onkey event.
however
it doesnt work when i press CTRL + BREAK on a USerform.

Guten Tag
Habe folgendes Problem mit Excel:
Ich möchte in der Zelle A1 ein beliebiges Datum eingeben. Excel soll dann in
den Zellen A2, A3, A4, A5 immer ein Jahr später einfügen.

Is there any way to format a column of email addresses, so if I click
on an address it will open up a new message in my email client?

I very familar with Excel but have not done much macro or VB programming. I
would like to create a formula which will prompt for an input number, do a
calculation (referring to specific cells on the spreadsheet) and place the
result in the selected cell. Example:

How can I change ( or set ) data that are in a column in rows to columns in
one row.( such as cross )
Best Regards,
Saeid.

I am pretty new to Excel but I have been using it and opening spreadsheets
sent by others for a while.  However, i got one today from a client that has
a problem.  I can certainly read it on screen.  But when I go to print
preview I get a completely blank page.  When I try to ...

Can anyone explain the purpose of having both the floating dollar sign
and the fixed dollar sign? Thank you.

I found the following formula that works but it seems overly complicated. My
goal is to just get the right most word from a string, for example if I have
"Now is the time from all good men" in A1 the formula I want in B1 should
return just the single word men. Is there a simpler ...

Hey everyone.
Thhis formuls works ok but I just noticed that it will still leave a % in
the destination cell (L13) even when one or more entries are made into the
cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in L13