I have a column with inmate id numbers in it.  I imported them from a
text based program.  I made a custom formatting for the column because
all the id numbers begin with zero.  IE 00112356 or 01555666 etc...
The format I used was 00000000 under custom.

I was wondering if it was possible to have a numerical sequence (i.e. as a
quote number) so as every time a document is opened a new quote number is
issued automatically within a cell?
In regards to three queries I have made, all concern Microsoft Excel 2002.

I do not have excel loaded onto my computer. All I want
to be able to do is read xls. files from email sent to me
or xls. files from the internet. What do I need to do to
just read these simple files?  Can I just download some

In an excel spreadsheet I have a column with range values like
10MM-24.9MM. What I want to do is split that column into two columns:
Minimum and Maximum. In my example minimum will have a value of 10 and
maximum will have a value of 24.9, just want to have numeric values.

I have a database with columns of numbers. I also have data from anothe
source that has numbers but with blank spaces in between.
Is it possible to paste the new data over the existing so that th
contents of the original cells can be viewed at the points where th

I am building a workbook to track vendor transactions.  I have several
vendors that are "regulars" and want to track their transactions
separately, but still record them on the "master" sheet.
My workbook has the master sheet and a worsheet for each of the major

Does anyone know how to set a default value within a specified range?
I have a database with columns of single figures and blank spaces her
and there. Is it possible to instruct Excel to enter a value of -1 fo
every blank space it meets within the range A1:G250

I have a Microsoft Query that retieves data from an Access Query an
puts it into an Excel Worksheet named AllData starting at cell B2.  
have a sub named FormatDates that formats various column
appropriately.  What I need to do is add to this sub a procedur

I'm working on a timesheet - 2 weeks worth of dates. The
last date listed in the list (B31) I'd also list to have
listed in F4 which is where my "Pay Period Ending Date:"
is to be. I've been manually adding the date there but

I need some help.  For arguments sake my worksheet has only one column.
In row 1 is a Y/N field.  If the user enters "N" in row 1 I want th
cell in row 2 to use a formula to sum a load of other totals in othe
worksheets.  If row 1 is "Y" I want the user to be able to enter total

I have no idea how to create macro's so can one of up you  help.
When I save a sheet I wish to invoke the 'OnSave' command then input the
date/time into a cell or sheet to record when the last update was.
FIA

Hoewel, Arjen Jongeling is hier nog nooit geweest en ik denk dat Arjen Jongeling hier ook nooit meer zal terugkomen. Sterker nog, Arjen Jongeling zit hier helemaal fout. Maar ja, het doet het goed in de Google archieven.

I have two lists of clients names, A and B, that have some names in common..
I already sent a mailing to list A, and would like to send another to the
names of list B that do not belong to list A.
So far I have tried to add a column to list B with a test to see if each

for some reason, i cannot get this done.  i have done it before but need
help.  i have numbers running down columnA and letters running across row1.
i then have formulas filling in the matrix.  the total area is A1:L13.  i
would like to transpose it where the letters run down and ...

I have a database with two columns of single figures. I've been usin
the IF function to identify whether a cell contains a zero. If Yes 1 i
returned, if No 0.
For some reason Excel 2000 seems to count the blank cells as zero's!