I have ever changing data base that imports as both mixed upper/lower and all
caps. I want to change all text to initial caps. Any formula in EXCEL to do
this?

Is there a way to create a "proability distribution" in Excel? I am in a
statistics class and it would be really helpful.
Thanks!

How can I convert a whole number representing seconds, e.g. 460, 1259, 82
etc into a number that displays minutes and seconds?
For example, 460 divided by 60 shows 7.66 minutes recurring and I want it to
show 7 minutes 40 seconds or 7.40

I have a spreadsheet containing over 3000 lines of data. Looking through the
row numbers some rows are "missing". However, pointing the cursor over the
missing rows it is possible to expand out each row individually. So for
instance row 2110 is followed by row 3003. Using the ...

In my program, RANGE will be change eveytime.Like first time  A1:B35 , Next
time B2:D234, Third time C22:E46, ..etc. So that can you suggest how to
store(find) the RANGE using Mouse Selection in a variable.
Have a nice day to all..! Thanks in advance for your reply.

I have a formula in ColB of my worksheet.
The value of the formula will be zero or a positive number.
Is it possible for a macro to change the formula to its value if the value
is not equal to zero ?

I just finished a spreadsheet last night that was opened from a flash/jump
drive and saved back on it after editing.  I took the drive to work and now
it is saying that is a unable to read file.  So I brought the drive back home
and it still won't open--saving unable to read file ...

I need to look at a single cell and it will contain a value from 1-1000, I
want to return different letters based on the cell value. Using ranges for
different letters>>
Example - 1-100 will return an A, 101-150 will return a B, etc. all the way

I am a teacher and am working on excel for my grades.  I am tyring to write a
formula that has an output of a letter grade. For example =if(AND (AQ3<100,
AQ3>90), "A"    but then I want the condition of =if (AND(AQ3<89, AQ3>80),
"B"  and so on.

Sometimes - especially when I copy/paste from Access - dates look like dates,
I can format the cells as dates, but they're not *really* dates.  For
instance, if I format the cell as a number, I should get the serial date.  
Or, if I change the date format from mm/dd/yy to m/d/yyyy ...

We are paying the health benefit to our employee on a quarterly basis
(calender base). We considered that if an employee joined the company between
1 Jan and 31 Mar we will count it 1 quarter and the same till end of the
year. Our employee is eligible for $1,000/year or ...

This is somewhat of a repost from here
http://msdn.microsoft.com/newsgroups/default.aspx?&lang=en&cr=US&guid=&sloc=en-u
s&dg=microsoft.public.excel.worksheet.functions&p=1&tid=a03f118b-30ff-44dd-b40c-
111e8759696c&mid=0bbda325-f240-4478-9724-167609028fd7
I have this formula.

The goal of this is to be able to format only part of the text in a cell.
I am trying to create a line of text which changes formatting depending on a
number of variables. What I am after is a system which will turn a line of
text (e.g. llllllllllllll and be able to manupilate ...

I have a number of people who will enter data: name, date, age, gender.  In
order to avoid having Joe inadvertantly change that which Bob has entered, I
would like to create a data entry form that would feed the data sheet.  This
way, Joe wouldn't have access to what Bob entered ...

Am trying to do a countif when the criteria can be one of many from a list
I am currently using
=(COUNTIF(INDEX(A1:j12,,2),Sheet2!$C$3))+(COUNTIF(INDEX(A1:J12,,2),Sheet2!$C$4))+(COUNTIF(INDEX(A1:J12,,2),Sheet2!$C$5))+(COUNTIF(INDEX(A1:J12,,2),Sheet2!$C$6))+(COUNTIF(INDEX(A1:J12, ...