General

Date Related Query
hi need help again.... I have this Data Date Submitted On-Time 3/14/2010 x 5/29/2010 x 3/12/2010 I have to count the number of on time delivery(with x) of tasks for a certain range example from 3/8/2010 to 3/14/2010...for this case the return value should be 1..I hope this is clear ... 1 Jun 2010 02:12

Undeletable mark--amazing properties
A mysterious, undeletable mark appeared in an Excel 2003 spreadsheet. It looks like a forward slash, but half-length and more sloped (45-deg.). It won't delete, but it copies to other cells and to an empty spreadsheet! (copy available). Writing in or pasting to the cell merely overlays the mark, and doesn't replace it... 1 Jun 2010 13:06

Getting contents of adjacent cells
I want to divide the y1-axis column and save it to radius (y1/2) column. How do I do that? x-axis y1-axis radius(y1/2) 0 0.00 8.0000 1 0.25 8.0242 2 0.50 8.0691 3 0.75 8.1281 4 1.00 8.1989 5 1.25 8.2803 6 1.50 8.3716 7 1.75 8.4729 8 2.00 8.5832 ... 31 May 2010 21:52

How can I put a text box in every cell?
Two questions: -How can I put a text box in every cell that I am using WITHOUT having to insert on manually every time? AND - How can I make sure that a text box inserts itself automatically into a new row whenever I add a row? Thanks! ... 1 Jun 2010 14:12

I want to add or subtract a range of cells
I am trying to add a range if another range is "D" or subtract if the "D" is an "R". I have used SUMIF to add the range but cannot figure our how to not add those with criteria of "R" and in fact subtract them with criteria of "R". Example: =SUMIF('Inventory Sheet'!B$9:'Inventory Sheet'!B$10000,A9,'Inventor... 31 May 2010 18:36

Unwanted reformatting of protected cells
I have a number of spreadsheets in which I have columns formatted in a particular way - e.g. Time to display 00:00:00 or ID formatted to display as a Number with no decimal places. All of these cells are protected (so I believe should NOT be allowed to change without my active involvement in that change). H... 31 May 2010 16:24

The last day
Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last years. Sharing knowledge is a great thing After tomorrow we must use the MS forums and I hope it will give me the same fun as I hade with the newsgroups. Maybe... 2 Jun 2010 16:30

Saving to disk
But, I'd like to save to a CD Disk to transport to & from work. I don't have the optionn to save to Disk E which is my CD Drive. How do I get the program to recognize my Disk Drive E? I am curently backing up to A floppy and J Zip drive. "RWN" wrote: Do not save/open directly to any removable media. ... 31 May 2010 16:24

how to turn off standard toolbar, formatting... Microsoft Excel20
On 5/31/2010 9:14 AM, Gord Dibben wrote: Excel 2007 does not have those toolbars. Maybe you are using Excel 2003? Gord Dibben MS Excel MVP On Mon, 31 May 2010 08:19:01 -0700, meaganicole <meaganicole(a)discussions.microsoft.com> wrote: Hello, I would like to know how to turn of... 1 Jun 2010 15:19

Filter on Pivotable
Dear All, pls help me. I work with Pivitable : Iem , Code and Qty. exemple: Item Code Qty 1234 10AA 25 1424 25BB 52 1475 10AA 32 1475 514S 14 2300 14CA 8 When I filter code 10AA, i want all Items contains code 10AA and with other code. result that i want. Item ... 31 May 2010 13:05