I have pulled into Excel a lot of information from a database, unfortunately
the database has only 2 characters for the year in a date field do people are
having their dates of birth set as 24th June 2047
How can I correct this in Excel?

I need to return the 2nd lowest value in a contiguous number array but I want
to exclude zero values, how can I write this formula?

I need to be record in a column several numbers these need to be added up
with the sum returned as a code39 barcode, the numbers will be entered and
the barcode printed, these numbers will then be deleted and a new lot of
numbers added, I need the code39 barcode to automatically ...

I've made an Excel-sheet (Office 2000) that calculates Sudoku solutions.
I's there a way to hide the macro's in this sheet to prevent the users
to see how it's done? I don't think it can be made with the lock function
since the users are supposed to write and delete numbers in the ...

I'm running a report to show the turn-around times for a task, but want to
exclude weekends and holidays.  For instance if an employee began working on
a task on Friday, March 9th 2007 4:00 pm (column a) and completed it on
Tuesday, March 13th, 2007 4:00 pm (column b), I want to ...

Is there a way to convert dates into their respective fiscal quarters.  For
instance, if A2 = 10/15/07, I want A3 = Q3.

I have two worksheets with several columns of data but only have one common
alphanumeric column type, combining in Worksheet 3. I want to keep all
Worksheet 1 (new) data. If Worksheet 2 (old) has duplicate in comparable
column, then only keep Worksheet 1 data. If not, then old ...

i am new to excel - i have 20 spreadsheet files created by a music program,
they are all song-lists used by the program.  i want to make a new excel file
combining all those lists into one so i can print or send the file.  how?
also, can i then search that file for artist or title ...

Sheet1 - logged ticket books to sales persons
name   beginno   endno
a          51          100
b          101        150

Can anyone tell me why buttons i put in an excel workbook shrink
everytime i click them?  If they don't shrink then they stay the same
size but the font gets bigger.  It is so odd.  Can anyone help?

How do I change the dates in a pivot table from showing up according
to calandar year and make them show up fiscal year? My fiscal year
begins April 1st. I am wanting to choose 2006 as my year and then have
the months begin in April of 06' and end through March of 07'. Thanks

i need to post 2 dates in a single cell (eg. 15 & 20) and at the end of that
row there is a count formula covering this cell.
How to post the dates in the single cell, so that the count formula counts 2
dates

I have a large customer list, and want to check for duplicate records that
might be slightly misspelled.
First I will use a formula that will check the first 8 or 10 characters of a
customer name and look for a match in the list.

I want to take a column of numbers and assign a rankig number from highest to
lowest.  I want the Rank to auto calculate... see example.
A (value)       Rank
98                   1

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces.  I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore.  Can anyone please help?