I have the following spreadsheet:
Cell A1: Last Month In Financial Year
Cell B1: 3
Cells A3 - A999 : various dates in the format dd/mm/yyyy

Does anyone know how to convert degree/minutes/seconds to decimal degrees in
an excel spreadsheet???????
36°13'53.23" should equal 36.23145277...
Any help would be appreciated.

I have just upgraded and excel 2000 worksheet tabs were previously hidden.
How can I unhide them in 2007?

i created a cloumn (not filtered) to number each of my rows but when i filter
my rows my number column oes not stay numbered it filters along with the
others even thow its not filtered!?!

I want to calculate the number of bagtags in my excel sheet and have the
result come out in ranges.  Can you please help me create a formula for this?
Note:  a cell may also have a value of 0.  I would like the formula to
result in a blank cell when the value is zero.

I am trying to find a formula to state if I inter a v or a d in this field
from a different book then put the # from another field in here. Can someone
help me with this

I've been trying to solve a problem using functions and could use some
insight.  The trouble is worksheet_A names are a smaller subset of
names contained in worksheet_B.  I'm trying to match the directory
path from worksheet_B to their respective names on worksheet_A.  I'm

I HAVE TO BRING THE GOAL SEEK DIALOGUE BOX, EVERY TIME I MAKE A CHANGE IN THE
DATA. CAN GOAL SEEK BE PERMANENTLY SET , SO THAT I GET ANSWERS AUTOMATICALLY
EVERY TIME I CHANGE THE DATA & NOT HAVE TO REFER TO GOAL SEEK EVERYTIME.

I'm racking my brain; I thought there was a command called gosub that would
take you to a routine in your macro and then return to the gosub command.
for example.
sub test()

We do a lot/most of our basic reporting in Business Objects and then export
to Excel and then run macros to provide the finished product. We can
pre-schedule BO reports to run which is great. Now, if only we could
pre-schedule the Excel macors to run at pre-set times, based on, ...

Using a SUMIF function, what wildcard could I use to sum only the CAD-EC’s
($9,000)?
Obviously, “CAD-EC-*” doesn’t work. Or does it, and I don’t know how to use
it.

I have a set of data rangeing from $1-$1000 and my professor wants us to use
the IF function to determine the shipping rate based on the amount of money
from $1-$1000. I am using an IF function and the problem that i ran into was
that i when determining the shipping charges for ...

Numbers (Dividends) are entered in Rows B1 to M1.
Divisor numbers are entered in Rows B2 to M2.
I would like quotients to appear in Rows B5 to M5.
How do I enter a formula in B5 that can be copied through to M5.

I'm trying to use the query function within excel instead of Access.  If I
really can't join two different queries the function is not much good to me.  
However, if there is a way, then I can develop many reports for our end users
without trying to teach them Access.

love excell but still so much i dont know, can some smarty out there please
help?
i am using excell to track tasks to be done. i have a column of "due dates"
and would like that when i open the file each day for the items that are due