When I export data from QuickBooks to an Excel spreadsheet, the function
feature appears to be turned off.  I type a correct syntax function into a
cell, preceded by an "=", formatted as "general" and with the "option"
function view turned off, and the following is displayed ...

I have latitudes and longitudes in two different columns. these are
expressed in degrees, minutes and seconds, with North or West labelled
as well.
I would like to know if there is a formula i can use in another column

On my spreadsheet I have the cells setup for Date formatting, Mar-98, when I
enter anything other then a month and year in 2006 and then double click on
the cell it changes the year to 2006
Example - If I enter Mar-08 in the cell and then double click on the cell it

Is there a function to extract the URL part of a hyperlink in another cell?
All I can see is the displayed text for the link.
if I use, for example, =A1 in another cell, all I get is a
copy of the displayed text.

I have constructed a document by laying out a template on worksheet 1
and inputting info on worksheet 2. To input new information I insert a
row however the corresponding formula cells on worksheet 1 change row
number to follow the already inserted line. Protecting worksheet one

I have over 90,000 records in my text file and I would like to import the
records into Excel.  I am only able to import the first 65,000+ records but
receive a message that through the Text Import Wizard I should be able to
exclude data already imported and import remaining data ...

How do I write an "if" statement to group a price list?
For example, if I have a list of prices and I want to group them in $10
increments
Under $10

I have a shared spreadsheet, which houses raw data on the second tab.
I don't want everyone to be able to see this data.  I know that I can
hide the cells that contain the data, but I was curious to know if I
could hide the entire tab, and make it appear that the tab doesn't even

A1 =1996
B1= 1
C1=1
A2=date(B1,C1,A1) and outputs 6/19/1906 instead of 1/1/1996

Hello I'm quite stuck, I'm trying to create a macro while the worksheet
is protected and the thing is i click unprotect and the password
dialogue box appears asking me to enter password which is fine, but can
i create a macro so that when it is played it opens this dialogue box

I am working on a pricing spreadsheeet.
In one column I have all of the products and next to it the price
ie: a14 prices is listed in C14
by the customer info (same worksheet) I have created a drop down validation

I have a graph of Force(mN) vs Distance(m). The error in the force is
0.0001g and the error in the distance is 0.0254mm. I have 10 points on
the graph. Excel gives R^2 = 0.90. My gradient is 1.045. What is it's
error? Can someone help?

I have to  build a lot of logic in to trap errors that are returned with V or
H lookups and it would be nice to be able to just return a 0 if the lookup is
an error.
If there is a way to do this I am not aware of it.

I have created the following forumula:
=IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old")
What I want to do is leave the cell blank - I Don't want a 'space' or the
FALSE written in the cell.  How do I remove this?

How do I re-check or modify the data range that a pivot is referring to?
Thanks
Stilla