Anyone got teh check digit formula for Excel
so I might convert a 12 digit barcode number into a check digit'd 13 number
code?
TIA

After installing the Office SP3 update I can no longer save files as .wq1 or
as Lotus 123 files.  That worked fine in SP2.  We have thousands of files in
that format.  Is there a setting somewhere that blocks this that can be
reset?

In Excel 2003, I have a list of values in a column and want to return the
last entry (ie highest row number) in the list to another cell.  Can this be
done?

I'm not even sure the title of this post is correct but it's as clear
as I could make it!
I'm creating a summary sheet of data from many other worksheets. The
worksheet names are mmm-yy (e.g. Nov-07). The top row of the summary

Hi world,
This is my log (20k) <http://img2.freeimagehosting.net/uploads/
32373110dd.png>
I have been trying to adapt a dynamic chart tutorial from Jon Peltier

I am about to purchase Excel 2007 (MS Office Home & Student 2007 Version)...
What I would like to know is exactly how can I install it along side my
other version of Excel (version 2002 XP)?
I generally use the XP version for most of my development at work, but I

Ok I have created a Workbook using 3 pages Tab1=RPM_Main, Tab2=PPS and
Tab3=Laps.
I have the info from cells on Tab2 and Tab3 going to Tab1, However on
Tab1=RPM_Main in certain cells there is nothing to compute and is given me an

I have a small worksheet that adds up sales in a year and compares it
to sales in the previous year.  I also have a column showing the
difference in $ between the two.  I would like to know the formula
required to get the fourth column to tell me the percent difference

office 07 How can I make up a working rota in excel

I am still running XP and my Outlook express for some reason changed to
French, Fun tot start with but now a real pain in the butt! Any  Ideas?

I have a column of numbers.  Some numbers vary in the number of characters
and some are strickly numbers; others are a mix of numbers and letters.  I
would like to replace those numbers with the same numbers but with
parenthesis around each of them.  How do I do that?

I have the code below where I would like ALL but ONE of fields to have the
text set to BLANK and made visible.
How can I add a statement to only set X.Text and X.visible values if it isnt
ME.combopatient??

I'm using Excel in a MacBook Pro (17", NVIDIA GeForce 8600GT, and 4GB RAM)
the OS of which is Vista.
Everytime I stop working for a few minutes (even when I pause for less than
2 minutes), I find Excel frozen when I resume working. It takes about 1

This is quite complex to explain but here goes, below is a mock up of my
user form:-
Label Title    <Value>  *Populated from result of combo box1
Combo Box 1    <Value select>

Having made the switch to Office 2007 last year, I'm having trouble
remembering some of the drop down menus and procedures under earlier
versions of Excel.  A friend want to freeze the first row of a spreadsheet
and this seems to be one of those things very simply under 2007 but ...