Search:

As far as know, no. What you can do is create a second sheet, put your formulas in this sheet and then protect it with a password and as a last step you can hide it.

Numbers have a limited precision of about 16 digits (sometimes 15, sometimes 16 depending on the number), which is usually more than enough for mathematical calculation. If you need to store this...

I would look in the direction of the printer driver on this computer and eventually re-install it.

You need to install an extension, as the "Open Document Format" is only supported as of Office 2007. I found this link to a free extension but I have not tested this extension.

This is a duplicate entry, I posted an answer in the other one. Could a mighty moderator delete it?

On my computer, the tab appears as a small square, indicating an unknown character.

If you want to remove the tab at the beginning of some cells, you could use the following formula in H1:...

The best way to speed your query is to make sure that there is an index CustomerID on the table Archive.

I just created a sample file with the formula =RAND() in cells A1:A1000000. It took about 7 seconds to calculate. I then transformed the formulas into fixed values, then sorted the million cells,...

Calc 3.2 only supports 65,536 rows in its windows version. The Ubuntu version supports one million rows, like Excel 2007.

You would then need the same number on the SIM card. I guess that your phone operator will only deliver one and if you claim you have lost it, they will disable it and give you a new one. So I...

It is very annoying that the e-mail programs prevent sending .exe files as attachments, but I understand the reason: to prevent malicious activities. I don't understand why you can't rename the...

A font is like a software: you should always get it from an official vendor and pay the indicated price. In your case, I doubt you will find a genuine, free version of this font on the Internet....

I now have a better understanding.
I will put in A3: =MATCH(A2,E2:E12,1)-1
And in B3: =MATCH(B2,G2:Q2,0)
And in C3: =INDEX(G3:Q12,A3,B3)

Please let me know if it answers your question. If you...

An example would definitively be useful. I see something like:
=IF(AND(first condition >=, second condition <), INDEX(range, HLOOKUP(...), ROW()), False expresssion)

I am not sure that in Excel you can test the content of a formula with a formula. But in your case, if you only want information when the column A contains the word "Total", then you can use a...

As an active member of the separate OpenOffice.org forum, you may have more chances to find answers to your questions there.

It seems that you have used the plain "Paste" menu option instead of "Insert cut cells".

The function RANK(value, range of values) corresponds to your needs, I guess. If two candidates have the same score, they will be ranked equally and the next one will be ranked with a rank +2 (12,...

There should be a file Outlook.pst in this folder:
C:\Documents and Settings\squenson\Local Settings\Application Data\Microsoft\Outlook (replace the part in red by your own user name).

This...

In Word, you need to have a section break to define a different page layout. After your last line of the portrait page, use the menu Insert > Break > Section break type "Next page". Click on this...

The bootup password prevents physical, direct access to your computer, like your car key prevents someone to use your car without your consent. On-line hackers are looking for software flaws in order...

If you don't want to use the keyboard, you can also right-click the row, then select "Cut", then right-click the destination row (this row and the ones below will move down) and select "Insert cut...

I have maybe the explanation of this strange behavior.

Excel uses numbers to represent the dates: 1900-01-01 is 1, 1900-01-02 is 2, 2010-01-31 is 40,209. The time is a fraction of a unit, so...

In such case, the function COUNT(range) is your friend! It returns from the specified range the number of numeric values.

Two other useful functions: COUNTBLANK(range) will count the number of...

I think I understand the problem. From your description, you are not using the FullAddress field (e.g. "Wellington Rd. 39") for the page break, but the field Street which is equal to the first 6...