I want to make a round up formula that will round up prices to the
nearest £5.  For example round 13.70 to £15.  Would appreciate someone
telling me how to do this.
Many Thanks in Advance

I have data that represents, rise and set times for the sun and moon
over a time span of 12 months. Data for each consecutive month appear
in joining columns as follows:
       January                         February

I have a handed down assignment to collect weekly employee whereabouts of
300+ in a spreadsheet. Currently the spreadsheet is updated each week by
sending out an e-mail asking for state, city, client, and contact # (example:
PA, Glenside, Rohm Haas, 555-555-5555). When the info ...

I want to know how do I check if the text string starts with a specific
character in if statement.
I used ...
=IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK")

If you create a .csv file, and you only paste the value "ID;xy" into it, and
open it in Excel from explorer, Excel crashes.
I've tested the behavior on Excel 2000, 2002 and 2003. Both Danish and
English version.

Here is the question/problem explained:
I have created a Mail Merge document in Word.  The information that is being
merged into the document is coming from an Excel file.  All of the mail
merge fields have been set up in the main document (and are labeled the

could someone point me in the right direction please.
I am working on a spreedsheet that i can use for a po log. on the firs
sheet i want to have a list of items  (date, po number, name of vender
cost and account number.) on the second sheet i need it to sort th

I would like to know how to calculate fiscal week of the year.  for
example, the first week of the year is started from Feb 1, 2005 instead
of Jan.

I have never used excel b4 and need 2 sum the columns in a workbook.
Can someone please tell me in laymens terms how to do it . If I click on the
funny E icon I just get  =Sum(0) in the cell I want the total for that column
to appear.Please help!

I need to convert some tps files to excel format.  Any help as to how
to get this done would be greatly appreciated.

You protect a worksheet using the tools menu. But is there anyway yo
can lock a specific range of cells and not the entire worksheet
--
guil

Normaly Excel opens in the way it was used the last time.
Showing the tool bars/Options that were used the last time.
I want that my file opens in someone else his PC under Full Screen, no
mather how his Excel was configurated the last time.

Below are a couple of cells which I want to split:
CEL
ewf ewf wef 5
wef 6

I'd like to be able to change a formula depending on what the selection is.
What I want is to have a small list, preferably one that cannot be changed
in any way, and when the user selects one choice, it changes the formula in
another cell.  Any thoughts?

I'd like to know how/if it is possible to automatically clear a cell when
the user presses the Enter key.  Any thoughts?