Is there a way to protect only certain cells from being changeable by
the user?
I have some cells with formulas in them, but if the user puts a value
into that cell, it really screws things up (e.g.  the user can end up

Forgive a basic question - I am new to Excel.
All my numbers come out with two decimal places. E.g. I enter 1234 and it
appears as 12.34
There must be a way of changing this setting, but I can't find it.

I know I've seen this somewhere but either I'm asking the wrong question or
Excel online help sux.
Given a named range, MyRange, which is 2 Columns wide by 5 Rows high
How to I refer (either in formala and / or in Macro ) to any particular cell

I'm looking for someone to help me write an easy macro
for excel. I don't know VBA at all and think that it's
impossible to do it with stepwise programmer. The thing
is that i have a file that has many cells. Each cell

I'm looking to be able to keep an excel workbook on some webspace and allow
others in a group to access and edit it directly.  What is the best (most
efficient way) to do this?

I have Excel 2003 installed on my desktop computer as well as my laptop.
I believe this agrees with the EULA.
On the desktop, I have added  some commands to the main menu (the menu
that contains File, Edit View and others)  that I always want to be

i build a line chart and i don?t want excel to show the zero values.
the first thing i did was to include an if function to substitute zer
with blank fields. (="")
the if function is: =IF(J30="","",J30-J29)

I created a few array formulas in excel 2k at work, but when I brought them
home to excel 2k2 sp3 the formulas are replaced by their final value.  Also
all of the conditional formating I had done to the sheets is missing.  Is
there any way to open the file without having the ...

I've got a grid that says:
           Hr    Min
Maths:  5        25
English: 7        25

I have a simple spreadsheet for my daughter to use to keep track of her
savings account. The only data entries she makes are the date (column B),
the details (column C) and then a monetary amount for either a deposit
(column D) or a withdrawal (column E). Column F keeps a running ...

when i open excel and click once on a single cell, the
cursor starts to select everything when i move the cursor
as if im holding down the left click button. anyone know
how to fix.

I'm using xl 2000.  I want to place several tables on the same worksheet.  Is
it possible to change column widths of a table without affecting the column
width of the other tables.

I don't normally use Excel or any spreadsheets but need to convert
some XLS data into a dbf format.  Problem is that some of the info in
the spreadsheet runs over a couple cells and I want to be able to copy
those 3 sells into ONE data file MEMO field.  How do I combine these

I want to model revenue projections for salespeople and I'm having
some trouble.
  A            B        C    D        E        F
1                      Revenue

I have a list of cells and in each cell there is a sentence of varying
lenght that I want extracted. The one thing common to each cell is
that the final word of the sentences starts SEL_*** (*** represents
different numbers). I have tried Text To Columns using the underscore