What is the formula to ignore blanks?  In other words, there are some 0, so I
want to include the 0.  However there are some blanks and I want to exclude
the blanks.
Thanks in advance.

I am designing some tickets.
I would like them to be numbered 001-100 and used Fill Series to do
that.
I'm using a custom format of "000" so all ticket #'s have 3 digits.

Hi - I live in Cyprus and from the 1st January 2008 we will cease to use the
Cyprus Pound and convert to the Euro.
Unfortunately the Euro conversion currency tool add-in in Excel 2000 does
not support (yet) the Cyprus pound. Does anyone have a workaround for this

Okay, I am not exactly an Excel genius. I have an Excel spreadsheet form that
is protected from editing in all cells except for the cells that require
changing each time the form is used. For instance, A1 is protected and in the
cell is the word Name and A2 is blank and ...

Hi Everyone: Thanks for helping!
I need a validation formula that will allow input into a cell based upon the
data in a different cell. For Example: I want excel to allow only the word
"cash" to be entered in B1 if the word "apple" is in A1. If a word other than

I'm using excel 2000
I need a formula that will count the number of times Y appears in the
range F4:F1000, but will change to reflect the number visible when the
list is filtered

I tried this, but when I press Ctrl-F3 nothing happens. Is that because I am
using Office XP

I have a form written in excel 2003. Every cell on the form is locked except
the cells that require new info each time. For instance, cell A1 reads NAME
and cell A2 is blank and allows you to enter a persons name. At the top of
the form is a button that reads "CLEAR FORM". When ...

i have a worksheet with several pages to it..i did a split screen on on of
them, and when i saved it "somehow" (i was distracted on the phone) i saved
it to a blank worksheet...now i cannot get back all my original work cause
the worksheet is blank.  how can i find it?  in the ...

Hi gurus,
I've been searching for the topic but found nothing relevant. Say
there's a column A like this -
EUR 100

When I have to open Excel Worksheet from My Documents by double clicking
Worksheet Icon, Microsoft Excel program opens but the Worksheet does'nt. All
that I have to do is open Microsoft Excel, go to File Menu, select Open
sub-menu, select My Documents folder and open the file.

in my worksheet of one row i have five  radio button while in another row 2
radio button  ,how do i bifurcate between two rows of  radio button, i..e
because excel worksheet is considering all radio button in whole page as one
group. suggestion please....

I regularly paste hyperlinks into my spreadsheet, the hyperink is an ISBN
that generally starts with 0, which is of course ignored if the cell is
formatted to recognize it as a number.  I formatted the cells for text so the
numbers pasted aren't changed but when the numbers ...

I would like to send a single page from a work book that multiple sheets as
a PDF. Is this possible?
At the moment when i attempt to send by PDF it sends the entire work book.
As i said i would just like to send one page from a sheet.

I will try to keep this short but I want to make sure that I include all of
the details.
I am making an order form on excel. I want to be able to fill in the details
on one page and have that page sent over onto a new page that will in turn