Replies

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 number exactly and don’t plan to do math on it, type a single quote before it. It will be displayed without the single quote and treated as a text.

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:
=IF(CODE(C1)=9,MID(C1,2,9999),C1)
Then copy it down, then copy/paste special it as text back to column C.

This will not fix the first row (where the tab is in the 2nd position)

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, another 6 seconds. I filled in cells B1:L1000000 with the text “qwe”, then saved the file: 11 MB but the uncompressed content is 300 MB. It took a minute to save or re-open. I have 3 GB and an Intel Dual Core T3400.

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 believe that it is not possible.

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 extension, maybe the file has a special attribute, right-click on it and select properties to see whether it is read-only or system or hidden. Another solution is to use a service like http://www.mediafire.com which allows upload and download of files. It’s free and quite secure as long as the URL to the file is kept confidential.

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. Also, I have WIndows XP and Office 2003 and I don’t have this font, so your friend may have acquired it with the purchase of a separate software.

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 want to test for #N/A, you will have to use an IF(ISNA(MATCH(B2,G2:Q2,0)),”no B match”,MATCH(B2,G2:Q2,0))

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 formula using the FIND() function:
=IF(ISERR(FIND(“Total”,A11)),””,IF(B11>10,”Power”,”No Power”))