I have copied a column of figure from web in my spreadsheet.
Now when I try to add up those figure I get the result as Zero.
i have formatted them and still I cannot add them up.
Any suggestion will be of great help to me.

I have been having problems calculating formulas with the IRR function
(that's another story). I just tried to do a simple IF functin and am still
getting a formula error.
=IF(F11>0,F11*.44,"$0")

I have a date field which has a range of dates from 1850 - 1930
Each entry has dd mm yyyy
how do I
1) format all fields to read e.g. dd Mmm yyyy

Can anyone tell me why this: =SUM(AI13+AW13+BI13+BW13+CJ13/5)) returns 34440%
in the destination cell when AI is 89, AW is 90, BI is 78, BW is 71 and CJ is
82??? I don't get it.
Cheers

I want to buid up a database for store detailed information of customers.
The key words would be contained Customer's name, contact, visited time,
email address links ( That can be easily used for sending emails).
I wonder which program is better, Excel or Access? I am thinking that ...

How do i print "&" in the header or footer of a worksheet. If i put "Wisson
& Wisson" in footer, the & does not print and  i get Wisson  Wisson. is
there a web site that shows how such things are done?
Thanks in advance.

Hey there Roger, once again this formula thing is driving me crazy...I can
visualize what I want to do but can't work out the formula...This is how I
see it in my mind
=IF(AI13,AW13,BI13,BW13,CJ13="N","",IF(AI13,AW13,BI13,BW13,CJ13="R","",SUM(AI13+AW13+BI13+BW13+CJ13/100))))

Some time in the past I was advised of an add-on that allowed early dates in
the 1800s to be recognised
Could somebody refresh my memory as to the add-on
Bob

I am trying to create a new worksheet when a cell has a date entered
into it
For instant in Worksheet 1 you type into cell B11 a date
I would like to automaticly create a new worksheet and call it that

XL 2002 SP3
Win XP HE SP1
Follow-up to: microsoft.public.excel
How do I count errors #N/A in column A that has both errors and proper

I'm playing with the Office 2007 and I can't figure out what a particular
Excel feature is for. It's on the Page Layout tab, under the Arrange menu
and it's called Selection Pane. It brings up a Selection and Visibility
pane, but I don't know what it's used for. Anyone know?

Any way to do this?  I found some old reg key fixes that don't seem to
work on 2003.  Any help is greatly appreciated

I am trying to create a new work group when a cell has a date entered
into it
For instant in Workbook 1 you type into cell B11 a date
I would like to automaticly create a new worksheet and call it that

Want to be able to count all value in particular range that have a
value that appear in list of multiple values
eg have spreadsheet all different types computers and what versions of
o/s and service pack they are running

i heard that you offer 10 free sessions where do i go???