I have to cells formatted as date dd-mm-yy.
I one cell when I fill in dd-mm-06 I get dd-mm-2006
I the other cell when I fill in dd-mm-07 I get dd-mm-07
Only a format "Text" solves this problem.

In excel 2003,
is there a limit to the number of named cells or named ranges you can
create?
thx

I'm wanting to get a future value, but can't find a complete explanation of
nper. I'm wanting to set up a 12 month future value but with bi-monthly
payments. Would this be accomplished by FV(rate = rate/12, nper = 26) I don't
want FV() to calculate 2 years and 2 months of ...

Using Win XP, Excel 2003.
I have hundreds of telephone numbers (exported from Outlook) in a worksheet
column, some local, some international, all formatted as "General"
1) A formula or  function to convert the following?:

I'm trying to use sumproduct in a situation with two arrays of
numbers. It works in the place where the arrays are contiguous,
looking like sumproduct($A7:$A15,C7:C15). However, in one place one of
the arrays is alternating with strings. (This format was decreed from

Is it possible to make a drop down list in an Excel cell? If so how do I do
it?
I am hoping to be able to export it into my Pocket PC.
I am using Excel 2002

help please....
i am trying to create an order form.  normally this would be easy
enough...item price x quanity etc, but there are some other variables.
allow me to explain....

I have been using excel for several years now and over the past few
years I've been running across the need to copy a value from one cell
to a selection of cells without the formula changing or a portion of
the formula. For example, cell A1 contains the formula =A2+A3. If I

Dear Ng,
Its probably staring me in the face, but I don't see it. Can anyone
tell me if it is possible to extract just the row subtotals (actually
averages) from a Pivot Table? There would be 88 averages, each

Can anyone tell me the way to display the latest entry into a range of cells
in a downward entry
e.g
A1 3

I have a work book that I use for a time sheet. It contains four
worksheets 1) "blank time card" 2) "employees 3) "job numbers" 4)
"totals"
What I am trying to do is take the value from range "b8 to b31" ( the

Dear fellow Excel 2003 users,
I have a pivot table that lists hours of several employees.  A manager
asked if there was a way to view just the non-billable hours.  No
sweat, I added a page field and selected non-billable and the sum of

Good Day,
I have a question as to why all of my listboxes, when clicked, display
the first blank data (after the last alphabetical text), requiring a
user to scroll up instead of scroll down.  How can the listbox always

I created my own toolbar and that's the only toolbar I want to see on
startup.
I overwrote Book.xlt in XLSTART.
However, whenever I start Excel 2003, the Standard toolbar keeps coming

Can anyone let me know what I have to do to get the windows back that show's
the cell reference for where you are. This has gone missing along with the
window that's used to type the formula into
Sorry to be a pain on a triviality, but I can't find the answer anywhere