im making a timeline plan for school, and when i enter the date such a
3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont hav
enough room for. is there a way so it doesnt automatically change it?
and the other is ive already typed up my table, disregarding the fac

Urgent !!
How can we abe to save the worksheet and at the same time still able to
protect the VBA project coding for viewing ? This development is just like
creating a Template with many macros programming and you do not want the

Does anyone have a good quick way to sort this list of IP addresses?
     10.198.16.206
     10.198.16.220
     10.198.16.248

I am having a problem trying to open a file in excel.  This file is ending
in xls.  When i go into windows to open the file i get a message saying to
either select a program from the list or use the web service.  Please help.

I am new to Excel and was practicing with a worksheet.  I wanted only to
place a $ sign at the first number in the column.  When I go to the next
line without using a $ sign and type only my number the alignment is
slightly off to the right.  For example: $    91, 000

I'm creating a checking account balance sheet and I want to display the
balance which would be the last column (F), and last row that the data was
entered.
I will then like to copy the cell with the ending balance and have it shown

I created a spreadsheet with three columns from data pulled that may not be
correct. One of the columns is MAC address which I know there are duplicates
in this column.
Based off the 500 rows, I am trying to figure how can I find out where a MAC

Is this possible?
Find all cells in a column which match an item from a pull down list.
Perform a sum of those rows in a different column and divide by a count of
the matches to obtain an average.

First off let me say I apologize for not keeping my Microsoft Office skills
up to par. I just spent a few hours making a very nice-looking, printable
member registration form using Excel. Unfortunately, I now want to be able to
convert it to PDF, and make it so that the answer ...

i wish to create a graph that has only 2 values.  the first value is a
yield, 3%, which i would like to be a bar;  the second value is -10%, which
is a policy constraint that yield shall not fall below, which i would like
to be a line covering the entire graph perfectly ...

I am a novice user of Excel and do not yet know how to create formulas
beyond the very basic ones such as countif, concatenate, etc.  Are
there any good online resources that I can use to teach myself how to
do this?  Thanks!

The formula worked very well.
As you can see I am totally a noob to excel. And I have another noo
problem needed to be solve. can someone please help me once more.
Quetion #2: per say, I have a table of data, and I would like to exce

Just wanted to know if it is Possible to sort omitting any formul
activity?
I know, sounds crazy and doesn't make much since, but when I attempt t
sort, the data resorts back to the original position based on som

I am trying to create a sheet that will read 2 columns of another sheet
that has empty spaces between the data (Rows) and I want to re-create
the data in a new sheet that will re-fill the columns without the
spaces.. Thanks

I am new to excel and need to install the "data analysis" add-ins found under
"Tools" for an assignment for a statistics class.  I do not have the original
CD used to install Office 2003 and hope there is a way to access and install
these add-ins from the web.