I would to know if anyone could answer a question for me? I am using Excel 2000 with XP Operating System. When I set up a spread sheet and adjust my cells for...

I have found a function that I would like to be able to call from any spreadsheet in Excel. Currently, it only operates in a particular spreadsheet. Could...

I have a list of orders with product info, sales clerk and sales info in a spreadsheet. I am aging these orders so that I know if they are over 30 days, 60...

How can I build a function that will calculate an effective yield rate given that an individual can put in a lump sum at issue, have a different...

Assume that $10,000 is deposited in a savings account at the beginning of year 1 earning 5% and that $1,000 is deposited at the beginning of each month into...

I would like to know if I how best to convert the value created using Now() which displays the current time for various time zones. How would I increment the...

Can a string be built that contains a field with a hex value of "00" - spaces give a value of "40".

I have the following data in the left-most column and the results of a formula in the next: 0.006149 0.710222 0.004668 0.676867 -0.00354 0.49206 -0.01529...

I need split age information between two columns depending on the age (details below at the bottom of the message). For example if the person is 55 in column...

I'm using the above formula to return a blank cell or a 0 if my vlookup returns an N/A. Where this is a problem is that I have a...

I have a worksheet that has vlookup formulas that refer to another file. If this file is a semicolon delimited file, do I have to have it open for my master...

Any way to dtermine if the same value appears more than once in two different columns? Thanks.

Is there a comprehensive user manual for Excel worksheet functions out there anywhere? The help files that come with Excel 2000 are ambiguous and do not...

How do you set a password so that a worksheet can not be opened by any other users? I am more concerned about anyone opening rather than making changes. I...

I am working on a spread sheet that calculates hours worked in a week. The problem I am having is that no matter what time format I pick for the cells it...

First of all, thanks to everyone who posted reponses to my last request to figure out how to count the number of selling days so far in a month to figure out...

I have a worksheet that one of my sales people set up to track the materials for a job they are doing. They have seperated the various stages by highlighting...

I was reading a post from Hope that was asking about password protecting individual worksheets in a spreadsheet to allow sales reps to only access their own...

Every morning I prepare a sales report that I send out to the staff. I am saving files from our POS into tab delimited files and everyday when I open them I...

confused I followed the directions from Gord to the t and when I went to Tools-Marco-Macros the macro did not show up in the list. Am I missing a step? ...