I am surprised to find that Windows Calculator (calc.exe) seems to have
a higher precision than Excel. For example 2^64 in Excel yields
18446744073709600000. In Windows calculator I get 18446744073709551616.
The same restriction exists in OpenOffice.org too, although KSpread on

I'm stuck with a setting I can't remember...........
In Excel I recall there's a setting which u can enable and it brings up
a little green triangle in the bottom right corner...  can ayone tell m
where that setting is..............

VLOOKUP problem
Given Column I (C7) has a range of numbers, typically from 47 to 471
(The width of items to be packed in a box).
Given a number of box sizes in a Range named Bwsizes, typically:

I am using W XP and Excel 2003. I have an XLS file that was created
from a CSV file. Column D of the Xls file containd a great deal of data
that is still comma seperated. For example a row may have Ford, Chevy,
Dodge... Another row in the same column may have Dodge, Honda,

I would like to use enter row in my formula, instead of spelling out
A4:A2500 in my sumproduct formula.  Example...
SUMPRODUCT(--(MONTH(Closed!$A$4:$A$10000)<(MONTH($D$2)+1)),--(LEFT((Closed!$C$4:$C$10000),(MONTH($D$1)-1))=F$7),Closed!$H$4:$H$10000,--((Closed!$AP$4:$AP$10000)=$B9))

I'm pretty new to scripting and I am working with a sample I found at
http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/tips061
6.mspx
My question...
Can I add a parameter so that the version of the desired file is captured as

Hello: I am attempting to average columns that have headings o
Inventory.  My spreadsheet consists of the following column headings
Inventory, Sales, Purchases. Each week I run a query that post
Inventory, Sales and Purchases for 450 Inventory items.How can

When inserting object or clip art into Excel they do not print in the
finished document.
Bob

Is there a tool, or function that will analyze a range of numbers and
identify those numbers that add up to another number?
For example: I have a list of numbers.....
2

I have 2 seperate macro's.
Macro1 -creates a pivot table
Macro2- creates a workbook for each practice.
I would like to combine the two, so that after extracting data needed

Is there a way i can unmerge so that the value goes into all of the cells not
just the top left cell?

I have a cell range that has 3 different types of cells in it. It's about
training, some have date or period when training was completed, some have
"due" plus date or period, and some are blank, yet to be filled. I need to
add the blank cells to the due ones, tried countif but ...

I am using Excel 97 and I am trying to insert a picture file into a custom
header.  I see when the header box opens up that you can insert file but yet
it doesn't show me how to insert the actual file.
Any help is appreciated.

How do I draw a circle around a cell I want to highlight - I want to
see the text within the cell and colour the circle red. I tried
inserting a circle from the 'drawing toolbar' but I couldn't see the
text in the cell.

I need to add functions/conditions to my excel templates. For example,
check if it alphanumeric, length of the field.
I would appreciate if someone can direct me to some link or suggest
steps.