I need to round numbers via a custom format. I'm using:
##,##0,_);[Red](##,##0,)
That gives me exactly what I need as long as the number is > 1000 or <
-1000 .. there's a problem when the number is only 3 digits long, eg.

I need help in setting up a formula based upon a value.  What i need is, if
the value of a specific cell is between -49 - 29, i need an "OK" in another
cell.
So, if the value of (A3) is 12, then i want an "OK" to automatically come up

When using the “Look-up” formula for “Lookup value, lookup vector, result
vector option”, if an item description (lookup value) on my current file is
not found in my item chart file (2nd file), the incorrect item category (in
the 2nd file) result may be returned instead of a ...

I submitted a question earlier this morning (6/7) and received a message
saying someone had responded, but I am not able to see any postings after
6/5. What is the problem?

Do you know of a way to sort contents of a column from right to left? They
are formatted as text fields, even though their contents are numbers but they
are not consistent lengths of numbers.  Someone said I should change the
language to Arabic or something?

The dates in my column are preceded by and apostrophe.  Anyone knows a quick
way to get rid of the apostrophe.  I have about 3000 rows on the spreadsheet.
This is how the date appear
‘ 04/05/2007

Hi, can anyone help me on this? Let say we have 3 columns of data. I want to
show in another column for data that appears in all 3 columns. E.g.
    A    B    C
1    apple    orange    education

Hi does anyone know if there is a way to calculate how many days a person has
taken off over a running tweleve month period?  For example If a person was
off:
2 Days May 06

I have a large amount of data that I want to provide summary for.
Column A is product group (product 1, 2, 3 etc)
Column B  is unit cost price
Columns C onwards are units volume sales per month

my problem is that I have a list with duplicate entries and values attached
to them like this:
col a   col b
12      2

I'm trying to work out how to calculate the number of days a person has taken
off in a running twelve month period. For example if a person had been off 2
days in May 06, 3 days in December 06 and 10 days in April 07. The 12 monthly
total at the end of April 07 would be 15 days. ...

I have a worksheet that contains some raw data.  In nne of the columns of raw
data (let's call it "Code") all of the values are formatted as text.  Some
example values in this column are: K4, K5, 11, K9.  In another worksheet I
have a series of DCOUNT functions that perform ...

I want to use the function sumif. but I have two condition.
sumif(sheet1!a2:a100, sheet2!B2, Sheet1!D2:D100)
based on this, I want to add that when Sheet1!a2:a100 = Sheet2!B2, the value
on that row of column C must be larger than zero.

How do I add a drop down box that will allow a user to pick from a list of
choices.  Also how do I add a radio button that would allow a user to input
an employee name, title, and then pick one of three levels of access (Input,
Reviewer, Approver)  These level of access would be ...