I need to make a column in a worksheet that will automatically enter the time
and date the info was entered in that row.. I have been playing with the
=NOW() function, but no luck so far.
Thanks!!

When I type a zero after my decimal point it disappears after I enter.

I don't know how to make a data table. Please help make one for me by tomorrow.

I have a spreadsheet that will not return the value of a formula. It
only states the formula.
If I have say a column of numbers A1 to A6 and put the formula
=sum(Aa1:Aa6) in A7 all that appears in A7 is the typed in formula not

I would like to learn how to make an excel spreadsheet that I could enter
codes and have the corresponding payouts sum up. I work as an installer for a
cable company and each job I do consists of codes for work done ( i.e. code
250 -Ran 1 outlet= $8.25, code 251- ran 2 outlets= ...

I have this quite annoying problem whít copy-paste special.
I've made a macro that copies range of cells to another worksheet.
Everything goes fine, but I need to add ' ', to every cell where I
paste cells. Cells containing only numbers are fine, with custom cell

I have three columns.  "A", "B", and "C".  I want to sum column "C" when "A"
equals a specific value AND "B" equals a specific value.
For example, sum the amuunts in column "C" when "A" equals "ball" AND "B"
equals "bat".

I'm trying to take 2 columns: 1 with a city name in it, and 1 with a
state abbreviation in it, and put them together using this worksheet
function:
=AB5&", "&AC5

I have a shared file on a server drive which is shared by a work group of
five users.
I can see the hchanges highlighted for the different users, and I can accept
or reject.

I just realized I inadvertently posted the following to the Mac/Excel
group.  I know x-posting is not desirable/necessary, but I'm using
Windows and thought the mac group might have less traffic.  Thanks.

Office 2007 Beta --- each time I open an Excel spreadsheet, all of the
columns have been re-sized. Normally 4 to 5 times their assigned widths.
Manual re-formatting is necessary but when the workbook is saved, closed and
re-opened, the column widths are re-sized again. I need a ...

I ran a macro and had it print to the Immediate window.  When I was done, I
cleared the window and closed Excel.  I just reopened Excel and the
Immediate window, and I see this:
[auto_open] <

I am trying to export data from a Word form to a Excel spread sheet.
The Word form has three data fields.  I want to export the form data to
a new row directly under existing rows in the spreadsheet (i.e., as
each new form is created I can run the macro and export the data to the

I am trying to write a formula that will change the date format. Here is what
I am trying to do. Can  anyone help?
I would like the date to be in this format in cell F1, 19971219. This field
needs to have 8 digits for the complete date.

Is there a way to get rid of the orange color when working in excel.
The orange shows up to indicate what Column and row you are in... but it is
very annoying...