Dear fellow Excel 2000 users:
I have a spreadsheet where there are 5 columns and thousands of rows
of data.  Every so often, there is missing data in the second and
third column.  I wanted to write some code that would, when it came to

I need some help with excel
I have this excel sheet
       A        B
1     11        2

This is a typical problem where I have a column of numbers that when
rounded, do not total to what you see on the screen.  Rather than using
the precision as displayed option in Excel, I would like to use a
formula that uses the ROUND function that rounds each cell prior to

This is a typical problem where I have a column of numbers that when
rounded, do not total to what you see on the screen.  Rather than using
the precision as displayed option in Excel, I would like to use a
formula that uses the ROUND function that rounds each cell prior to

I was sent some Excel files by email.  When I try to open one of them, it
will always open two copies.  Both are Read-Only.  I'm using Win2000 and
XL2000.  Any suggestions?
Ed

I am trying to use text from within one cell to be used in a formula of
another to reference a tab name. See below for example:
A         B
SOG       =SOG!F4

I have a workbook which has 12 sheets for 12 months (Jan,
Feb, March.........
Each sheet has 7 colums.
Please show me how Can I create a summary sheet which will

Column B (or a range within Column B) has a Data Validation List, that can
be one of 4 values (Test1, Test2, Test3, Test4).
When I change a cell in column B, I want to know which Row has been changed.
The following works when I change Row 2.  How do I make it work for the

I have a master document that is linked to 7 other excel
sheets. Now the other excel sheets are modified by
different users and the master document is for generating
reports.

It might sound a little weird, but I find Excel useful for
analyzing/reformatting HTML for various purposes, such as generating a list
of the links or images in a webpage. My problem is, I can't easily and
consistently get Excel (2000) to stop INTERPRETING the code. I have tried

What piece of code would I use for the cursor to go to Cell K12 on Open? I
have it going to K12 at the moment but K12 is in top left hand corner of
screen, I wish A1 to be in that position
Thanks

Hi, is there any tool, or method to reset the size of  coloumn  ( width) ,
hight to standard ?
best

Thanks for your previous advice, it worked like a charm!
Normal syntax, as you so kindly pointed out, is =IF(logical_test,
value_if_true,value_if_false)
I now have a situation where I have 3 ranges of numbers nominated by myself,

I have the following ?50...it is defined as a number without me doing
anything.  I have $50 ...it is defined as text without me doing anything.  I
have 10% sometimes (depending on the pc) it is a number and sometimes text,
similarly 10,000.  Now I assume that the ?50 is recognised ...

I use excel for my accounts & have used a column of hyperlinks to store
paths to scanned images of my invoices. However, recently, this system has
stopped working so well. When I click on a hyperlink I get the message 'Some
files can contain viruses or otherwise be harmful to ...