Back in 1981 I wreote a SuperCalc templates for a spreedsheet.  I ported
that over to qutoPro,  then to lotus 123, now to Excel.  I have just updated
to office 2003 and now my formulas show an error.  They still work but they
show an error.  During the late 80's i even went to a ...

I am creating a chart to map a round-robin chess game. If there are 4
players, then all 4 has to play one another.
if I have the names
John

I created a spreadsheet and made 51 more copies of it.  The first work sheet
has Report # 1, now i want to change the report number by 1 on each
spreadsheet, Report 2, Report 3, etc.
Is there a simple formula I can use so i dont have to change all 52

I am not sure how many people here are familiar with Bill of Materials but here is my question.
I need to find out how to get the values in column cost.
Level                           
1    2    3    4    Part Number        Qty        Cost                        Extended Cost

I have a field on my excel report which comes as a UnixTime
(1235502582).I want this to be in Excel readable format for e.g 24-
SEP-2009 21:20.The char is string type
I want to use this in a macro,since affer the data is downloaded,i

I have a two sheet workbook. The first sheet named "Financial_Data" performs
the calculations and saves the total to a cell named PTotal. I am trying to
develop a macro to open the next sheet (Historical_Data), insert the date,
then move into the next column  and paste the PTotal ...

I need to compare two cells (A1 vs B1) that contain letter grades
(that is, A, A-, B+, B, B-, etc.)  I need to show if one cell (B1) has
a higher grade than the cell to which it is being compared to (A1), is
the same or has a lower grade.

I run Excel 2K
I have a series of times that I download from the mainframe. (these are in a
date format)
EXAMPLE

On sheet 2 I have a 13 digit code in Col A, the description in Col B and the
price in Col C, these will be constantly added to manually.
On sheet 1 I would like possibly a 'drop down list' of the 13 digit codes in
column A, then for Col B to auto fill the Description and Col C to ...

i need to know how to make a column of cells increase in number from 1 - what
ever so i dont have to keep going from cell dropdown to next cell and so on.

I am trying to split a cell so I can enter data in both halfs of the cell. An
example would be to check a yes/no

Can someone please recommend some good book or web page about creating local
OLAP cubes using MS Query. I have some data in Access that I want to work
with using cubes.
Kind regards

In col A I have ABC
In Col B I have 001234
My formula in Col C is A1&B1.  The resulting answer is ABC1234.  I want it
to keep the leading zeros so it reads ABC001234.  Is there any way that I

Hoping I can get some advice to help me with a frustrationg situation.
I'm using Excel 2003 on 2 different XP systems. 1 is my primary system at home, the other at work.
I have a folder that has many excel, word, JPEG, etc documents in it that I send to a thumbdrive, take it to ...

I hope someone is able to help. The problem manifests itself in copy/paste
activity. When I highlight a cell then click on the copy command, the
spreadsheet whites out and stops working. Does anyone have a clue what is
happening. Using Office 2007.