I have a column of 0's and 1's. I need a formula to change
the 1's to "yes" and the 0's to "no".
Thanks for your help.
Tim

i came across a weird problem that i've seen before but
forget how to fix. When i open up excel and i single click
on a single cell, i then move the mouse and the mouse
starts to select everything. as if i was holding the left

Excell 2002 on a XP Pro.
How do I activate(?) the grayed out "Conditional Forma" on the Forma
menu.
TIA

I have a list of about 100 addresses. I have them in
Excel. I can sort the list by name, or phone number but
when I try to sort the addresses it comes out with the
numerical entry first. Here is and example:

I need to sort a column of 6000 items all CAS numbers. I have imported the
column as text from Filemaker so I presume the first step would be converting
text to numbers. The form of the CAs no is: #####-##-# (i.e the last two
coumns separated by dash always contain 2digits and 1 ...

Hi, im new at this and not sure on how to explain what I need done, bu
Im trying to make a bowling league summary with my teams high series
high games, averages and games over.  I was able to do the averages
and games over, but Im having trouble with high series, and high games

Im new at all this and Im not sure if Im explaining this correctly, bu
im trying to make a bowling league summary sheet which can tell th
players what thier high game is after each week.  I tryed to us th
what if formula, but it just gives counts.  I want a number total.  ho

I wish to know how many instances of a numeral are in a column.
I am using the following formula:-
COUNTIF($A$2:$A$101,1) to give a count of every occurance of 1 in the 100
row list in Column A.

My page up and page down keys don't work
Thanks,
-Paul

Hi
I have a model that runs like a dog and I am wondering if it could b
significantly improved with better hardware Or if it is an inheran
limitation of Excel.

Hi I'm trying to produce a timetable and each time I try and format
the cells so that I have day, date and time the time just reverts to
12:00am. I reformat the cell, but it takes no notice. I've tried
separating the two things out in columns and the time still comes up

In column A I have  twenty groups, in Column B ref#, In Column C First
Name, In Column D Surname and In Column E the numerical value.
The data  rows are from 2 to 534.
I can find the total and maximum for each group using arrays.

Hi to you all...
I have a small problem with ordering....
I want to have my data ordered by ascending order... problem is cell b
WONT order itself... why ?

I hope someone can help with this.
Column A I have numbers that look like TSC-10-001,TSC-10-102
TSC-10-052. Then they go to TSC-20-051, TSC-20-422, TSC-20-10, etc..
have set up data validation so that there is no duplicated allowed bu

Woman in our office was working on a spreadsheet.  She opened another XLS
file in the same window, closed excel and (long story short), lost her
entire day's work on the first document.  Is there any way to get this
document back?  I mean, she hit "No" to save, so I'm assuming it's ...