does anyone know of a way to not make cells convert numbers to date
when copy and pasting?  for example, if I copy and past scores from
baseball or soccer game was 1-2, excel automatically converts it t
"2-Jan"

1. How can I change the properties of a button on the Formatting toolbar? I
want to modify the currency style button so that when you click on it, it
will apply a currency formatting without decimals. The only way I know of
doing that is assigning it a macro. Is that the only way ...

would love to get an example of the right formula, thanks

I'm asking for help with the following.
I am using Excel 2003.
I have a time report from another system that I dump to excel.
The report contains many columns and about 10,000 rows of data.

I have a workbook which displays the "This workbook contains a macro"
warning when I open it. However if I look in Tools | Macros there's nothing
to be seen.
Is there anywhere else to look?

I type "=A1+B1" in cell C1.
Cell C1 displays "=A1+B1", not the result of the formula.
Tried CTRL +` but that just seems to make the colums thinner.
It's driving me nuts!

Hello.-
I want to create a sheet that gives me the products qty per week. First
I started importing data from MS Access. The data have PRODUCT, QTY and
DATE this information is on sheet DATA. These are manufactured

I have a workbook with 2 sheets. in the first sheet (sheet1) i have embeded
a textbox. Also in the first sheet there is a cell which shows a result of a
formula (the result can be 1, 2 or 3).
In the second sheet (sheet2) there is a shape (rectangle 1).

I’m struggling figuring out how you would do the following?
Work sheet data.
A1 =25 B1 = 40
C    D

I copied 4 columns from 1 excel doc. and pasted into another excel doc.  The
columns are: Bates No., Date, Summary & Box No. The excel document I'm
working in have the exact same columns.  I was trying to have one excel file
to work in.  When I went to sort the Box column, I ...

I'm using regular Excel formula in the cells (not scripting, mainly
because I don't know how). I have a problem with trying to combine
offset() and small()
my actual code is:

I'm a teacher at a high school with 1800 students.
The attendance lady types up an excel file each day
listing the tardies and early outs, etc. for each student
who comes in on that day for a pass.

 I have a spreadsheet with several hundred tabs.  All these tabs have data
in Column A only.  The data can be a in few rows or in one case, in 15,000
rows. There may be a solid line of data from Row 1 to the end of the tab or
it may have breaks.  I started a macro where I named ...

Excel 2003 SP2
Trying for format a cell based on the sum of a range in which the cell
exists versus amount in another cell.  So if the number in the cell changes,
making the total of the cells exceeds a predetermined number, then the cell

In column A, rows 1 through 31 data is entered in those rows 1 through 31
corresponding to the day of the month. I need to return the value of the
LAST entered amount in column A to A35. How can I do this?