How would I show a blank cell, instead of the number 0 in the cell, if the
formula in that cell results in an answer of 0?

Hey guys, I've searched high and low for a solution to this,  and as a
last resort, I've come to the forums for some help.
For range C1:ZZ3 , I have the following formulas,
C1 : =IF(DAY(C$3)=1,CHOOSE(MONTH(C

I am using Excel 2007, I am importing text files with about 500,000 rows.
This works fine. Problem is I then want to copy and peaste these 500,000 rows
into a new worksheet. However when you open a new worksheet it only opens
with 65,000 rows, so the peaste will not work. How can ...

I am using Excel 2003.  I have an Excel file that uses a query to obtain data
from an Access database.  We have changed the location of this database but I
have not been able to correct the path of this database in the Excel file.  I
am getting the below error.

I have a number of comments in some of my cells
Example :Sugar=200
salt=12
candy=400

I want to assign a number to a certain conditional format. When the
condition is true it should put a 1 in the cell and when the condition is
false a zero or nothing should be assigned. Anyone? I seem to make the wrong
code all the time.

I have a spreadsheet with customer information including thier social
security numbers listed in one of the columns.  I want Excel to sort the
spreadsheet in ascending order by the last two digits of the social security
number only.  How can I do this?

I am using Office 2003 and have the following problem:
I have a Sheet PROD (figures for example purpose only- it can be
numeric or alpha numeric)
    Col B    Col H

I was hoping someone could help.  Here's what I have.  Cell range
D1:T1.  each cell in range has a specific date.  I want to highlight
the date(s) in the range that fall within the next 7 days from today.
I was thinking this was fairly simple, however I can't seem to figure

I posted this yesterday ... could not see ... so reposting it again
Hello All,
I am using Office 2003 and have the following problem:
Sheet PROD (figures for example purpose only- it can be numeric or

I need some help.  I want to creat a spreadsheet with a drop down menu in
column A when you selct from the menu I want an amount to appear in column B.
So then I can add a qty in the next column and multiply, it for billing.
Can anyone help me on this?

Goodmorning,
I have a sheet contains names, adresses and email addresses. Which are
filled in by several people.
Is there a possibility to make an pop up if the email address not

I have two sheets in a workbook. Say sheet January and Summary. Sheet
January looks like this
DATE        SN    Amount    TAX    OVD    CBS
12.01.2007    483    3464    1559    701    1184

I have an sheet called inputsheet where data entry people has to fill
in email adresses. (in row N and H)
Now I want to be sure they fill in an "@" and an "." (dot) If not an
error has to appear.

I have an sheet called inputsheet where data entry people has to fill
in email adresses. (in row N and H)
Now I want to be sure they fill in an "@" and an "." (dot) If not an
error has to appear.