Any ideas which is the best format to import this to excel ? The file will be
more than 5 mb or so and with 7 columns of data. This is a log file.
MS Word *.doc
Rich Text Format *.rtf

Beste excellers,
Nadat ik via zoeken, vert zoeken een waarde heb opgehaald via een ander
bestand,krijg ik een waarde (getal; celopmaak standaard) te zien.
Bijvoorbeeld 5.56

My formula SUM(firstsheet:lastsheet) returns a #VALUE! error Why?

i am trying to recreate a record sheeti currently have a copy of but am
having trouble doing so.  like how do u have text go under each other in the
same cell etc. and and how do i put some text above the database but not part
of it as in a cell. sorry im not too good at ...

I have a worksheet called Input which has text in cells A3, A30, A57, A84 etc
which I want to copy to cells B4, B5, B6 etc of a worksheet called Creditors.
I can type =input!A3 into cell B4 of the Creditors worksheet and get the
correct answer but if I try to copy this to B5 I ...

Another office phoned me about a problem they are having with excel.
They had a large list of dates about 4600 columns long that were al
displayed as one long string of numbers, i.e. like 021105.  So the
went to format them into dates and they all ended up going into #####.

Please help me in configuring formula for the following problem:
I want a formula for the extra amount I am paying, by way of commission and
tax for the transaction carried out by me
The extra amount I am paying is calculated as follows:

I am importing Excel data that has what seems to be blank cells but on closer
inspection I can see an apostrphe in the formula bar. That's not a problem
because I have written a macro to identify apostrophes and clear the contents
of these cells.

I know this isn't the right forum to ask this question, but I hope to get
some responses from UK guys.
I would like to know if someone knows some good sites which would help me
calculate income tax for UK. Or if someone has a ready-made excel template

OK, I created an Energy Balace Chart to help me eat healthier and trac
my daily progress. Everything works as designed except for my Gran
Total column which I want to calculate once every 7 days. This is
sample of the formula I used

How do I delete duplicate sequential rows of data? They have the names and
addresses
from different sources but I only want 1 record for a mailing. Also, 2 of
the columns have

I found some great code for copying rows, that pass a particular test,
from one worksheet to another in this newsgroup and got it working in
my project. I'm trying to become a good programmer so I'm starting to
use style guidelines to produce professional-quality code. OK. I'm

I am trying to create a box plot in excel. My book says to go to tools and
Data Analysis Plus. I have already added data analysis, but I have no Data
analysis plus. Can anyone help?

My goal is to set up a situation so that with a cell is merely
touched/selected; it adds some values for reconciliation. My example has many
complex calculations that range over rows 10-19. The cell I want to have
selected in at Q10. However, I want to replicate rows 10-19 many ...

I have created a form which the user adds data to, on a button click
procedure I want the data to be check and then added to a spreadsheet.
I dont know how I would go about placing this data in the write
spreadsheet, in the ocrrect place.  I would need to place the data at