6018971032413880
That number is a big number but why is it if I try to chage the last zero to
a 3 while in Excel, the zero always comes back as soon as I hit ENTER
Thanks

I want to create xml file through excel.
I only have several attributes names.
How can I do? I am using office 2003 Professional.
Thanks,

Noticed that the review toolbar will appear when opening excel, when the
toolbar is one not requested.  I uncheck it from the toolbar selections and
it re-appears after opening a new excel session.  Is this a bug?

i used some the getpivotdata formula from one book to another (both open).
everything was working until i closed it.
So my question: is there anyway to use getpivotdata from a closed book?
(i tried to update the link, but nothing was working..)

Wins & Loss Records, (standings) for a Ten Team pool league, Play each other
2 times during the season.
Need to up grade records each week showing total points, wins & Losses and
the Percentage. Each team is sorted due to the 1st, ...to tenth place

I have a spreadsheet which has many dates on it and I need a
complicated formula to look them up I use the address() function to
convert it to a format weekday() will recognise, but it gives me a
#VALUE! error for no apparent reason.

HELLO SMART PEOPLE!!!
To be quite honest, I'm an idiot when it comes to Excel and I could use some
help (if possible.) The excel template I'll be refering to is linked to
here...

I have a large sheet with data. One of the columns is defined as a named
range (Key_x).
On another sheet, I would like to reference to some cells in that
column. Is it possible to use something like

In Excel 2007, I want to create a rule that turns cells red in case
that 3 out of 7 cells in a column equal 0. What formula will catch
this condition? Thanks to the math stars! Sven

We we several worksheets at work where there are  define names that do not
apply to any of those worksheets, some are really old.  I have a fix for
removing by downloading an add-in which I can delete all of those at one
time, instead of one-by-one. Question:  Does anyone knows ...

I have a range of cells that I want to count only if they are not empty,
regardless of whether the contents are numbers, text or formulas.
Since there is no 'NOTBLANK' function, how would I go about doing this?
TIA

I would appreciate any help concerning "check boxes".
This concerns a trucking company.
The company has multiple "runs" in different locations/states. Each "run"
pays a different amount.

I'm copying data from a web site to an Excel 2007 worksheet.
Specifically, I'm creating a database of my DVDs and using IMDB as a
source of information, specifically the release date of the movie.
Right now I'm copying the date from the web page, right-clicking on the

I would like to know whether it is possible to do something with the use of
a macro.
Could a macro be recorded (or written) that compares the data from a single
worksheet in one spreadsheet with the data in two worksheets on another

I am trying to  figure out how to have a macro run on the active row
and if certain conditions are met then do another function.
Example:
if the active row contains AAA BBB CCC in ANY order of the three