Hello;   how to highlight the smallest positive numbers, other than zero's, from a range of cells, in "conditional formatting" ?
Thanks for your help.

How can i fix a cell in excel for mac. I am a PC user and i allways used the
F4 key, but i cant find it for excel for mac.

 Is there a way for a macro to copy data in a row without referring to the
actual row number?  I have a spreadsheet with data on certain rows and I
want to copy that data to a new spreadsheet.  The problem is the relevant
row numbers tends to shift over time. Today the data I ...

Help,
Daily I create a spreadsheet from a database, In column "A" are "Item
Numbers" in random order. I insert a 'new' column in front of column
'A', where I type text comments as I receive verbal updates during the

Situation: I had a memo size field in MS Access. When I copied and pasted it
into an MS Excel cell the text gets truncated?
I can't believe that Microsoft has had about 5-6 versions of Excel and
hasn't fixed this simple problem.

I have multiple lists of part numbers, both numeric and alpha numeric in
varying digit numbers and wish to sort them.
Is it not possible to sort a column based on reading the cell from left
to right?  ie:001, 111, 2, 22-33, 3, etc.  

How do you assign a short cut key to a macro I created.  I am tryin to learn
VBA and am working on writing code.  I have been reading about the onkey
method. Where in the code to you enter the short cut key? After the Dim
Statement?

I have my budget calculator on an Excel spreadsheet.  In one table(TableA) I
enter my paycheck date and the 4 columns to the right of it get a currency
value from another part of the worksheet.  Right below that I have expense
descriptions I enter and their amounts which subtract ...

=count(B2:J10)
works in a macro, but how to use this function in VBA?
Hans

I have a long column of #'s that consist of positive and negative #'s
of differing values.  I am looking for a simple formula that will count
the number of #'s that are negative and divide that by the number of
values that are positive.  IS there an easy way?

How do I stop a calculation rounding up or down without extending the
decimal points.
I have a client who is having problems with her invoices, as it
sometimes shows a penny too much, as it has rounded up.  I realise that

I'm using Excel 2k on XP, SP1...
My problem is that I did something to lock (for lack of a better word) a
particular cell.  (No, I didn't do this on purpose.)  Now, whenever I click on
another row, Excel highlights all the rows from (and including) that "locked"

i want to know if this is possible... i think it is i just dont know
where to start..
here is my situation:
i want to calculate income tax to be withheld from a certain ammount of

I have collected about 1000 points of data from the HyperTerminal program and
saved the data as two file formats one being .txt and the othet .csv.  When I
load the .csv file I am not taken through the wizard which is okay.  When I
load the .txt file I am.  Anyways, my question ...

Does anyone know how to display an excel spreadsheet on a webpage. For
example I use yahoo geocities and would like to get my spreadsheet on
one of my pages. It doesn't even have to work. I just want to display
the spreadsheet. If you don't know anything about yahoo geocities maybe