I've been working on this sheet off and on for about 3 years and I think I'm
about done with it.  However I have one lookup that I can't seem to figure
out.
To help see what I'm trying to explain, you can download the file at

I've got the following problem:
A1 cell is formatted as percentage with 2 decimals.
When I want to edit the contents, the result appears to depend o
whether you choose BackSpace or Del button, or overwrite.

How can I force text which is entered into a column to
be upper case?
-Thanks

I'll try to be specific -
I have a situation at work whereby I need to enter the start of
postcode/zip code - and it returns which field worker covers tha
area.

I have one column of telephone numbers, please can someone help me
with a formula to create another column showing how many occurrences
there are of each number. Thanks!
Andy.

While when I try to Save My Excel File the system is Hanging .
I had also Reinstalled the MSOffice but the Same problem exits.please
Give me any solution to solve this.

hi everyone, im stuck again, and was hoping someone might be able t
point me in the right direction to what im doing wrong again.
i have tried to do the following two ways with both gives me tw
different wrong answers with my test data.

I have been using my Excell database for the last three months with n
problems.
Recently, in the column where I have to type in a telephone number
which commences with "0", e.g. 017723-, the 0 is shown on the scree

Hi, I have three Excel 97 formula questions:
1) Suppose I have a formula which yields a dollar value with a theoretically
infinite amount of decimal places, but I use column formatting to limit the
decimal places to two positions. For example, the formula:

I want to format a row based on the value of one of the
cells in the row.  Basically, I want to set the color of
the row to green if a particular cell in the row is
COMPLETE and red otherwise.  How can I do this?

I USE A FORM FROM 95 THAT IS USED AS A PURCHASE ORDER FORM BUT IT IS NOT WORKING CORRECTLY THE PO # IS TO FIND THE LIST OF NUMBERS ON THE SERVER. IT SEEM AS IF THAT SECTION IS NOT WORKING. HAS ANY ONE USED THIS FORM? IF SO SOME INPUT TO REPAIR OR RUN/

... due to formatting changes or something my the
contol+end takes you to the very last possible cell
available. How can I reset Contol+End to take me to the
last cell of actual Data?

Excel 2002
WinXP
Brand new to excel
I put together a chart that has my blood pressure measurements

I'd like to automatically copy this If-Statement into a cell using a macro.
=IF(OR(C1="05",C1="07",C1="10",C1="12",C1="03",C1="01",C1="08"),"31",IF(OR(C
1="04",C1="06",C1="09",C1="11"),"30",IF(C1="02","29","")))
Thanks for your help.

I'm a biologist working with some circadian rhythm data. I need to be able
to make a chart in excel where the X axis is dates, with correct phases of
the moon for each phase. What is the easiest way to get moon phase series
into an excel sheet?