Hello Bob/RD
I hope this isn't too cheeky, but I fear my query about "validating times"
has now sunk down the list of threads - but I'm not quite there yet!
You both kindly suggested some vba code to get the times formated as I

Is there a way to extract info that is in the File>Properties box such as
subject or author, and place it into the worksheet? What I really want to do
is have the value in a custom field in the Properties box, show up on a
worksheet cell.

I have a spreadsheet with 6 worksheets, each of which has a button with
corresponding onClick event code.
In my final worksheet I have a button that when I click I want it to cause
each of the onClick events of the other worksheets buttons to fire.

Help!   I am going round in circles trying to resolve this, I have a
workbook with two sheets in it the following sheet detailed as below
and named Prices
Code    Type                   Size    Price

I have Excel 2003 at work and Excel 2000 on one of my computers at
home. I am not sure how much this feature differs between the two
programs, but I am defintitely experiencing this problem on my work
computer:

I have a church supper list that charges $7/adult and $3.50/child.
Everytime I want to calculate that, I have to go under the total
column and write the function for each individual cell in the total
column. The function looks like =B4*7+C4*3.50, and so on based on

sent a spreadsheet that has some rows hidden & I cant figure out how to open
the whole spreadsheet up

I'm using Excel97 under WinXP-pro.  (I know it is old, but it does most
everything I want.)
When I go to add a comment to a cell, the first row of the comment box
displays my name probably as a result of my selecting the option when I

I have this weird problem.
I have written a function to calculate how many days, hours & minutes people
in my business work. In the VBA editor the function result is correct, but
when I go to Excel the function returns the wrong value.

Is there a way to take a .pdf file that started as a excel file and convert
it back to Excel. I am not the creator of the .pdf but I do have Adobe
professional 8 and Excel 2007.
Thank you.

I have a column and all I need is the last 5 characters in this field.
Problem is that this field has various text lengths. How can I get the last
5 characters and delete the rest. My spreadsheet have 1,000 or so lines.
This Column looks like this:

based on 100% view, when u set the column width to say 12 units and the row
height to, for example, 15...
what is the actual dimensions in reality in mm.
ie, how can i get the required number to ensure that row and colms are

In excel 2003 is it possible to split a cell into 3 or 4 cells in one
particular row without it affecting the col setup in the rest of the
worksheet?
Joanne

Hello all, I have created a box with a macro assigned to it that will
highlight the cells that have changed from one tab to the other. When I click
on this box the macro runs but I would also like to be able to click it off.
Could someone please help me with this? I have copied ...

I have a worksheet I've been using for years, which has started misbehaving.
I created a complex formula and wanted to document it with a cell comment. I
can insert a comment correctly the first time, but if I try to edit or
resize the comment, it disappears and the cell flashes ...